If you take =SUMPRODUCT(COUNTIF(A1:A10,{"Tom";"Beth";"John"})) , is it possible to setup 3 named ranges to hold 3 separate values instead of typing them directly into the formula i.e.
=SUMPRODUCT(COUNTIF(A1:A10,{namedrange1;namedrange 2;namedrange3}))
I tried but couldnt figure it out.....
:-)
Quote:
Originally Posted by Peo Sjoblom
=SUMPRODUCT(COUNTIF(A1:A10,{"Tom";"Beth";"John"}))
--
Regards,
Peo Sjoblom
(No private emails please)
"Harley" wrote in message
...
I need to count different criteria from the same column. For example,
under
the column Names, the criteria for one breakout might be Tom, Beth, John,
Roger; the next breakout might be Joe, Sue, Randy, Bob.
|