Conditional Sum

[Heckstein]

Hi!
I have included a word file .
I need to calculate what the accumalative sum be for the a specifi
date.
THANK

+-------------------------------------------------------------------
|Filename: Excel Help.doc
|Download: http://www.excelforum.com/attachment.php?postid=4713
+-------------------------------------------------------------------

 

[VBA Noob]

Hi!
I have included a word file .
I need to calculate what the accumalative sum be for the a specifi
date.
THANKS

Hi Heckstein,

If you make the formula a array it should work. e.g Shift, Ctrl an
enter


Code
-------------------

=SUM(IF($B$1:$B$11="CAC",IF($A$1:$A$11=J3,$C$1:$C$11,0),0))

-------------------



Note your answers where wrong should be

CAC DAX
01-Apr-06 40
02-Apr-06 0
03-Apr-06 -20
04-Apr-06 -10
05-Apr-06 0
06-Apr-06 0
07-Apr-06 0
08-Apr-06 0
09-Apr-06 0

VBA Noo

 

[Guest]

Attachments almost always reduce your chance of getting an answer. How about
describing what you want, what you have tried, and what is wrong with the
results that produced.

Jerry