Forum Discussion
Solved
Sumif with an AND requirement?
Hi, I'm trying to create a document whereby I can see which products I have sold to which customer. Attached is a basic version - the Import tab I will paste in data exported from my MRP system ...
- You may use a simple SUMIFS in B5, copied down rows and across columns, like this:
=SUMIFS(Import!$M:$M,
Import!$F:$F,$A5,
Import!$H:$H,B$3)
You may use a simple SUMIFS in B5, copied down rows and across columns, like this:
=SUMIFS(Import!$M:$M,
Import!$F:$F,$A5,
Import!$H:$H,B$3)
=SUMIFS(Import!$M:$M,
Import!$F:$F,$A5,
Import!$H:$H,B$3)
- You're very much welcome!