# CountIfs Formula Question - adding a second criteria

1. ## CountIfs Formula Question - adding a second criteria

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

2. ## Re: CountIfs Formula Question - adding a second criteria

try...in Row 2(Untested)

``Please Login or Register  to view this content.``

3. ## Re: CountIfs Formula Question - adding a second criteria

I use pivot table for that.

See for an example the attached file.

4. ## Re: CountIfs Formula Question - adding a second criteria

I used

=SUMPRODUCT(--(\$H\$2:\$H\$62="Item 1")+(\$H\$2:\$H\$62="Item 2"), --(MONTH(\$C\$2:\$C\$62)=MONTH(C2)),--(\$E\$2:\$E\$62=E2))

There are currently 1 users browsing this thread. (0 members and 1 guests)