Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Have an excel formula question.?
In column I I have a list of states, in column B I have whether those people from those states can attend a conference or not.
I am trying to find a formula that will count the number of acceptances from a certain state so I can keep track. I googled CountIf formulas but I came up empty handed.
2 Answers
- garbo7441Lv 76 years ago
You have more than one criteria, so you have to use the COUNTIFS function (for Excel 2007 or later only) or the SUMPRODUCT function for any version of Excel.
I prefer the SUMPRODUCT function.
Assuming column B contains 'Yes' or 'No',you can use this example as a guide. Change the number of rows to a higher number if you have more than 100.
=SUMPRODUCT((B1:B100="Yes")* (I1:I100="CA"))
Note: if you are using Excel 2007 or later you can use this variation:
=SUMPRODUCT((B:B="Yes")*(I:I="CA"))
- momoftwinsLv 66 years ago
THANK YOU!!!! you have no idea how long I have been messing this with this, you nailed it!!! thank you so much!!!!!