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
try...in Row 2(Untested)
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
I use pivot table for that.
See for an example the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
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))
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks