sumproduct+sumifs+multiple criteria

[MilindP]

[TABLE="width: 580"]
<tbody>[TR]
[TD]mode
[/TD]
[TD]party
[/TD]
[TD]item
[/TD]
[TD]qty
[/TD]
[TD]books
[/TD]
[TD]textbooks
[/TD]
[TD]depots
[/TD]
[TD]pencils
[/TD]
[/TR]
[TR]
[TD]Cash
[/TD]
[TD]Depot1
[/TD]
[TD]Book100pg
[/TD]
[TD]100
[/TD]
[TD]Book100pg
[/TD]
[TD]TextBookB
[/TD]
[TD]Depot1
[/TD]
[TD]PencilDark
[/TD]
[/TR]
[TR]
[TD]Cash
[/TD]
[TD]Depot1
[/TD]
[TD]Book200pg
[/TD]
[TD]25
[/TD]
[TD]Book200pg
[/TD]
[TD]TextBookC
[/TD]
[TD]Depot2
[/TD]
[TD]PencilLight
[/TD]
[/TR]
[TR]
[TD]Cash
[/TD]
[TD]Depot3
[/TD]
[TD]Book200pg
[/TD]
[TD]65
[/TD]
[TD]Book400pg
[/TD]
[TD]TextBookE
[/TD]
[TD]Depot3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash
[/TD]
[TD]SHOP
[/TD]
[TD]PencilLight
[/TD]
[TD]150
[/TD]
[TD]Book800pg
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chq
[/TD]
[TD]SHOP
[/TD]
[TD]Book200pg
[/TD]
[TD]150
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chq
[/TD]
[TD]SHOP
[/TD]
[TD]TextBookE
[/TD]
[TD]75
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chq
[/TD]
[TD]SHOP
[/TD]
[TD]PencilDark
[/TD]
[TD]75
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chq
[/TD]
[TD]SHOP
[/TD]
[TD]PencilLight
[/TD]
[TD]35
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Chq
[/TD]
[TD]SHOP
[/TD]
[TD]TextBookE
[/TD]
[TD]144
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]190
[/TD]
[TD="colspan: 5"]SUMPRODUCT(SUMIFS(qty,mode,"Cash",item,books))
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100

[/TD]
[TD="colspan: 6"]SUMPRODUCT(SUMIFS(qty,mode,"Cash",item,pencils,party,depots))

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]wrong answer with multiple criteria for the same.
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

Please don't start a new thread for the same question you were already working on. Thread closed.