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