Hi ,
I'm fairly new to formulas and I want to compare two tables and have specific output
Example:
formula.PNG
At the right I just want to have how many are yes and no for specific color.
I've have tried with countif formula , but it's adding all counts for each color. Instead of matching how many are for red,blue,etc..
Any help would be appreciated.
Try COUNTIFS instead:
=COUNTIFS(criteria_range_1,criteria_1,criteria_range_2,criteria_2)
So, something like:
=COUNTIFS($B$4:$B$12,$E4,$C$4:$C$12,F$3)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You're awesome!!!!
That's the formula that I was looking for!
Thank you!
And 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