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

Hi Heckstein,

If you make the formula a array it should work. e.g Shift, Ctrl and
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 Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=537862