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
Promoted
Excel: How do I get it to count 1 if two values in a row are true?
So if A2 = Male and B2 = Academic then it would count one, and do this for the rest of the table.
1 Answer
Relevance
- ?Lv 57 years ago
=IF(AND(A2="Male",B2="Academic"),"1","")
This will give 1 if the values match, otherwise blank.
Still have questions? Get your answers by asking now.