formula explanation ?

Absolutely nothing.

This would count non-blank cells (comfirmed with ctrl+shift+enter):

Formula:

=SUM(--(B1:B5<>""))

But no need to use array function for that since you can simply use =COUNTA(B1:B5)

Originally Posted by stars

Hi

I came across this formula {=SUM(B1:B5<>"")} in an excel model. Can someone please explain what it does.

Thanks

I don' see any logic in the above formula since sum doesn't consider the Text and Blank cells.