I am trying to count two columns IF a 3rd colum equals a certain text.


This function will count the two columns just fine:

=COUNTIF(Sheet1!AG:AG,"600-KRF5792S")+COUNTIF(Sheet1!AG:AG,"600-KRF5899S")

but when I try to say I only want to count those two columns IF the third
column equals a7 i get a formula error. Im counting columns in Sheet 1 and
puting the totals on Sheet 2.

=COUNTIF(Sheet1!AG:AG,"600-KRF5792S")+COUNTIF(Sheet1!AG:AG,"600-KRF5899S"),COUNTIF(Sheet1!AC:AC,!A7)

So, my question is can i do a conditional Count or should I use an array of
some sort to figure it out?