Posted to microsoft.public.excel.worksheet.functions
|
|
Counting with multiple matching criteria
Thanks!
--
Gary''s Student - gsnu200858
"NBVC" wrote:
If you array-enter (CSE) your formula, it gives you the results.. I
think.
or use:
=SUMPRODUCT(COUNTIF(G7:G3147,K1:K4))
--
NBVC
Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109662
|