formula explanation ?

[stars]

Hi

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

Thanks

[zbor]

Absolutely nothing.

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

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

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

[:) Sixthsense :)]

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.