software

Hi!
I have included a word file .
I need to calculate what the accumalative sum be for the a specific
date.
THANKS -------------------------------------------------------------------
|Filename: Excel Help.doc |
|Download: www.excelforum.com/attachment.php?postid=4713 |
-------------------------------------------------------------------

--
Heckstein
------------------------------------------------------------------------
Heckstein's Profile: www.excelforum.com/member.php...oamp;userid=27153
View this thread: www.excelforum.com/showthread...hreadid=537862
Heckstein Wrote:
gt; Hi!
gt; I have included a word file .
gt; I need to calculate what the accumalative sum be for the a specific
gt; date.
gt; THANKS

Hi Heckstein,

If you make the formula a array it should work. e.g Shift, Ctrl and
enterCode:
--------------------

=SUM(IF($B$1:$B$11=quot;CACquot;,IF($A$1:$A$11=J3,$C$1:$C$ 11,0),0))

--------------------
Note your answers where wrong should begt;
gt; CACDAX
gt; 01-Apr-0640
gt; 02-Apr-060
gt; 03-Apr-06-20
gt; 04-Apr-06-10
gt; 05-Apr-060
gt; 06-Apr-060
gt; 07-Apr-060
gt; 08-Apr-060
gt; 09-Apr-060
gt;
VBA Noob--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: www.excelforum.com/member.php...oamp;userid=33833
View this thread: www.excelforum.com/showthread...hreadid=537862Attachments 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

quot;Hecksteinquot; wrote:

gt;
gt; Hi!
gt; I have included a word file .
gt; I need to calculate what the accumalative sum be for the a specific
gt; date.
gt; THANKS
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: Excel Help.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4713 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; Heckstein
gt; ------------------------------------------------------------------------
gt; Heckstein's Profile: www.excelforum.com/member.php...oamp;userid=27153
gt; View this thread: www.excelforum.com/showthread...hreadid=537862
gt;
gt;