Sumproduct with multiple cells...

[OMGWATDO]

I'm trying to figure out how sumproduct works.

Here's what I'm trying to do:
Wn8XooF.jpg

I can solve that with sumif/sumifs, but I'm trying to compact the formula and use sumproduct.

[samba_ravi]

Try
=SUMPRODUCT((A2:A10=2014)*(C2:C10=1)*(B2:B10))

Please Login or Register  to view this content.

or
=SUMIFS(B2:B10,A2:A10,2014,C2:C10,1)

Please Login or Register  to view this content.