Thread
:
SUMIF (Excel 97)
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
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 With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann