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?
|