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