View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default 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?