Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (Excel 97)
=SUMIF(C8:C334,H8:H334<"",C8:C334)
I'm trying to sum the Range C8:C334 if the cells in the range H8:H334 have something in them, which could be anything. The above formula produces a blank result. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (Excel 97)
It should look like
=SUMIF(H8:H334,"<""",C8:C334) Make sure you add the quotes around the <"" "Phendrena" wrote: =SUMIF(C8:C334,H8:H334<"",C8:C334) I'm trying to sum the Range C8:C334 if the cells in the range H8:H334 have something in them, which could be anything. The above formula produces a blank result. Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (Excel 97)
Cheers,
That appears to add up ALL the cells in C8:C334 even if the cells in the range H8:H334 are blank. I need it to just add them if there is something in that range. any thoughts? Thanks, "akphidelt" wrote: It should look like =SUMIF(H8:H334,"<""",C8:C334) Make sure you add the quotes around the <"" "Phendrena" wrote: =SUMIF(C8:C334,H8:H334<"",C8:C334) I'm trying to sum the Range C8:C334 if the cells in the range H8:H334 have something in them, which could be anything. The above formula produces a blank result. Any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF (Excel 97)
try just:
=SUMIF(H8:H334,"<",C8:C334) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Phendrena" wrote in message ... Cheers, That appears to add up ALL the cells in C8:C334 even if the cells in the range H8:H334 are blank. I need it to just add them if there is something in that range. any thoughts? Thanks, "akphidelt" wrote: It should look like =SUMIF(H8:H334,"<""",C8:C334) Make sure you add the quotes around the <"" "Phendrena" wrote: =SUMIF(C8:C334,H8:H334<"",C8:C334) I'm trying to sum the Range C8:C334 if the cells in the range H8:H334 have something in them, which could be anything. The above formula produces a blank result. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif function in excel | Excel Worksheet Functions | |||
SUMIF (Excel '97) | Excel Worksheet Functions | |||
Bug in help for Excel SUMIF function | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |