Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Where A1:A5 contains the numbers and B1:B5 the are cells to be not empty.

=SUMIF(B1:B5,"<>",A1:A5)