LinkBack URL
About LinkBacks
How to I check Column C for the value of Y and if Y to count Column R all the way down the sheet?
This is what I have and its not working
=IF(C:C=Y,COUNTIF(R:R,"=A"),FALSE)
How to I check Column C for the value of Y and if Y to count Column R all the way down the sheet?
This is what I have and its not working
=IF(C:C=Y,COUNTIF(R:R,"=A"),FALSE)
Last edited by inkpassion; 09-12-2005 at 06:06 PM.
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks