| mode | party | item | qty | books | textbooks | depots | pencils |
| Cash | Depot1 | Book100pg | 100 | Book100pg | TextBookB | Depot1 | PencilDark |
| Cash | Depot1 | Book200pg | 25 | Book200pg | TextBookC | Depot2 | PencilLight |
| Cash | Depot3 | Book200pg | 65 | Book400pg | TextBookE | Depot3 | |
| Cash | SHOP | PencilLight | 150 | Book800pg | |||
| Chq | SHOP | Book200pg | 150 | ||||
| Chq | SHOP | TextBookE | 75 | ||||
| Chq | SHOP | PencilDark | 75 | ||||
| Chq | SHOP | PencilLight | 35 | ||||
| Chq | SHOP | TextBookE | 144 | ||||
| 190 | SUMPRODUCT(SUMIFS(qty,mode,"Cash",item,books)) | ||||||
| 100 | SUMPRODUCT(SUMIFS(qty,mode,"Cash",item,pencils,party,depots)) | ||||||
| wrong answer with multiple criteria for the same. |
<tbody>
</tbody>
