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