I have two colums one contains yes no and some are just blanks. The other is a list of names. I want to count the blanks in b and have it compare to a certain name in A. I can't quiet figure out the formula todo this.
A B
Jose Yes
Joe Yes
Jose
carl No
Randy
Jose No
carl No
Robin
mary Yes
Robin Yes
Mary
carl
Jose Yes
mary
Jose Yes
Robin
mary Yes
Hi,
you could try
=COUNTIFS(A:A,"Mary",B:B,"")
or
=SUMPRODUCT(--(A1:A1000="Mary"),--(B1:B1000=""))
Regards
Last edited by canapone; 11-11-2013 at 10:48 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Hi,
Assuming your data is in A1:B17, something like:
=COUNTIFS(A1:A17,"Jose",B1:B17,"")
Even better if you put e.g. Jose in a cell somewhere, say D1, so the formula is then dynamic:
=COUNTIFS(A1:A17,D1,B1:B17,"")
Regards
Those are not working maybeI forgot to mention that these are on two different sheets.
Hi.
maybe you could upload a sample file.
An attempt:
=COUNTIFS('Sheet 2'!A:A,"Mary",'Sheet 2'!B:B,"")
Regards
sample file.xlsx Okay please see attached for smaple file
Then you need, in B2 and copy down:
=COUNTIFS('Phase 1'!$A$2:$A$27,Count!A2,'Phase 1'!$B$2:$B$27,"")
Regards
Thaks that works
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks