Using of SUM function for the array.

Hi everyone!

As I didn't find an appropriate solution I want to ask if you could help me with optimization of the following formula using the SUM function. I eventually don't get it/get it wrong.

Initially I needed to calculate the number of cells (in a column E4:E18), which are filled in with numbers, so I've came up with the following solution:

=IF(E4<>"", 1)+IF(E5<>"", 1)+IF(E6<>"", 1)+IF(E7<>"", 1)+IF(E8<>"", 1)+IF(E9<>"", 1)+IF(E10<>"", 1)+IF(E11<>"", 1)+IF(E12<>"", 1)+IF(E13<>"", 1)+IF(E14<>"", 1)+IF(E15<>"", 1)+IF(E16<>"", 1)+IF(E17<>"", 1)+IF(E18<>"", 1)

I definitely realize, that this is a kindergarden, but modifying to:

=SUM(IF(E4:E18<>"", 1))

didn't give me a valid result.

Could you tell me, what should be changed?

Sincerely,
Alex

Maybe

=countif(E4:E18,">0")

Kind regards
Leo

Thanks! Feels awful

Thanks! I definitely have to go through the basic functions