| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Sum Help
Hi All, I have 2 sheets in one workbook. 1st sheet - March 18, contains: # # # OF ACCTS 1 5 10 1 5 15 1 5 20 4 10 500 4 15 1000 I want to, on sheet 2, sum the # of accounts Column D, when Column A = 1 and Column C=5. Column B has stuff I don't need at this point. I have this now, but it is returning only a zero. =SUM(IF('March 18'!$A$3:$A$10000="1",IF('March 18'!$C$3:$C$10000="16",'March 18'!$D$3:$D$10000,0),0)) Any assistance would be greatly appreciated. -- techiemom60 ------------------------------------------------------------------------ techiemom60's Profile: http://www.excelforum.com/member.php...o&userid=20124 View this thread: http://www.excelforum.com/showthread...hreadid=525065 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| 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) | |||
Threaded Mode
