Sum if not null

[Fred Smith]

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

 

[Max]

Fred,
Perhaps try something like:
=SUMPRODUCT(--(A1:A100<>""),B1:B100)
Adapt the ranges to suit. We can't use entire col refs in SP.

 

[Guest]

Try this:

=SUMIF(A:A,"<>"&"",B:B)

 

[Guest]

It seems to work okay w/o the &"".

=SUMIF(A:A,"<>",B:B)

 

[Max]

=SUMIF(A:A,"<>",B:B)

Above doesn't seem to return correctly if col A contained null strings: "",
which was what I thought Fred was looking for. That's why I suggested the
good, old Sumproduct way <g>.

---

 

[Guest]

I see what you mean. Good call. I'll have to try to remember that
particular "feature". <g>