Hi Bob
The expression
--(D4:D9={"8a","8b"})
returns a 2-dimensional (6 x 2) array
where
COUNTIF(D4:D9,{"8a,"8b"}")
returns a 1-dimensional (1 x 2) array
Either one might be useful depending on, which
functions are to be used on them.
To get the sum, either one may be used, and my
solution may be less memory hungry than yours,
depending on how Excel treats the functions internally.
OTOH it uses one more function call.
LeoH
"Bob Phillips" skrev i en meddelelse
...
"Leo Heuser" wrote in message
...
and for counting the numbers of 8a AND 8b
=SUMPRODUCT(COUNTIF(D4:D9,{"8a,"8b"}"))
Typos apart, why introduce a nested function call?
=SUMPRODUCT(--(D4:D9={"8a","8b"}))
|