Sum if not null
It seems to work okay w/o the &"".
=SUMIF(A:A,"<",B:B)
"Teethless mama" wrote:
Try this:
=SUMIF(A:A,"<"&"",B:B)
"Fred Smith" wrote:
I would like to sum all cells which are non-blank (same as selecting non-blank
cells in a filter). I tried
=sumif(A:A,"<""""",B:B)
but Excel didn't think much of it.
What is the correct criteria for 'not null'?
--
Regards,
Fred
|