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.