I'm working on a CountIfs formula for a very large spreadsheet. Right now the CountIfs formula limits to persons receiving both Item 1 and Item 2.
=IF(COUNTIFS($A$2:$A$62,A2,$H$2:$H$62,"Item 1")*COUNTIFS($A$2:$A$62,A2,$H$2:$H$62,"Item 2")=0,"",1)
However, I'd like to flag only data where in one month a person received both item 1 and Item 2. How could expand my CountIfs formula to limit by month/Column C on my example?
Thank you!
Christine
Bookmarks