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
Bookmarks