=SUMProduct(--($F$3:$F$37=$C59),--(G$3:G$37G$52))

This doesn't need to be array entered.

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
Hello,

I have read many of the posts on this site on this subject, but I am still
not able to get the formula to work. I have 2 columns that I am
considering:

Column F and Column G My current attemt is:

{=SUM(IF($F$3:$F$37=$C59,IF(G$3:G$37G$52,G$3:G$37 ),0))} This expression
seems to work to give me the correct sum. But instead of a sum, I would
like
to use Count. when I try to replace the word Sum and use the word count,
it
counts all of the rows. Not what I want to do. Here is a copy of how the
formula was in with count:

{=COUNT(IF($F$3:$F$37=$C59,IF(G$3:G$37G$52,G$3:G$ 37),0))}

Thanks for any help.