Conditional Sum

H

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
+-------------------------------------------------------------------
 
V

VBA Noob

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

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
Click to expand...
VBA Noo
 
J

Jerry W. Lewis

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
 
Top