hi,
I have text values going down one column (e.g. "School", "Community", "Home", etc). I want to count the number of occurences of particular text values [say 'school'] in the column except when I have marked the same row in the adjacent column with an "x". I know I can use countif to count the occurences in one column - is there a way to count contingent on value in the next column.
Thanks for your help
Richard
Perhaps a simple formula would be this:
=COUNTIF(A:A,"School")-COUNTIF(B:B,"x")
But of course you don't have to have the word in there you can reference another cell like:
=COUNTIF(A:A,C1)-COUNTIF(B:B,"x")
Not all forums are the same - seek and you shall find
Perhaps
=Sumproduct(--(A1:A100="School"),--(B1:B100<>"x"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks