| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Sum
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: http://www.excelforum.com/attachment.php?postid=4713 | +-------------------------------------------------------------------+ -- Heckstein ------------------------------------------------------------------------ Heckstein's Profile: http://www.excelforum.com/member.php...o&userid=27153 View this thread: http://www.excelforum.com/showthread...hreadid=537862 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Sum
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Sum
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 "Heckstein" wrote: 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: http://www.excelforum.com/attachment.php?postid=4713 | +-------------------------------------------------------------------+ -- Heckstein ------------------------------------------------------------------------ Heckstein's Profile: http://www.excelforum.com/member.php...o&userid=27153 View this thread: http://www.excelforum.com/showthread...hreadid=537862 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
| Conditional Format Not Working | Excel Discussion (Misc queries) | |||
| Conditional formula - language needed | Excel Worksheet Functions | |||
| VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
