J
Jakobshavn Isbrae
How can I count the number of items in a column whose length exceeds zero?
Rick Rothstein (MVP - VB) said:Or, I guess more simply (that is, one less function call), this...
=SUMPRODUCT(--(A1:A1000<>""))
Rick
Jakobshavn Isbrae said:Thank you very much for taking the time to offer help. The formula seems
to
ignore numbers.
I was more interested in its "scale of slowness" as opposed to the simple
fact that it is slower.
Rick Rothstein (MVP - VB) said:Yes, of course, wildcards... that works fine.
I find my inclination is to go to the SUMPRODUCT function because of it
vast flexibility as a calculation engine. I was wondering if you knew (or
if anyone else reading this message knows) whether the SUMPRODUCT is, by
its very nature as a universal type calculation engine, a necessarily slow
function compared to the more targeted functions (such as your COUNTIF
formula compared to my SUMPRODUCT formula)? I'm guessing the answer will
probably be "yes", but I was more interested in its "scale of slowness" as
opposed to the simple fact that it is slower.
Rick
Jakobshavn Isbrae said:Thank you very much for taking the time to offer help. The formula seems
to
ignore numbers.