How to I check Column C for the value of Y and if Y to count Column R all the way down the sheet?
I inkpassion Sep 12, 2005 #1 How to I check Column C for the value of Y and if Y to count Column R all the way down the sheet?
C Cutter Sep 13, 2005 #2 I assume you want to know if there is a "Y" anywhere in column C and, if so, then count the number of times "A" appears in column R. Try this: =IF(COUNTIF(C:C,"Y")>0,COUNTIF(R:R,"A"),False)
I assume you want to know if there is a "Y" anywhere in column C and, if so, then count the number of times "A" appears in column R. Try this: =IF(COUNTIF(C:C,"Y")>0,COUNTIF(R:R,"A"),False)
