How Can I do a SumProduct With Filters?

[nycraja]

A (Stock)
Facebook
Amazon
Netflix
Google
Facebook
Google

B (Action)
Buy
Sell
Sell
Buy
Sell
Sell

C (Quantity)
100
50
75
100
100
50

D (Price)
150
1000
150
1000
175
800

What's a formula if I wanted to see how much I spent on buying just google? (Google + Buy -> Quantity * Price)

Thank you!

 

[Marcelo Branco]

Welcome to Mr Excel Forum

Try
=SUMPRODUCT(--(A$2:A$100=F2),--(B$2:B$100=G2),C$2:C$100*D$2:D$100)
where F2=Google; G2=Buy

Hope this helps

M.

 

[nycraja]

Welcome to Mr Excel Forum

Try
=SUMPRODUCT(--(A$2:A$100=F2),--(B$2:B$100=G2),C$2:C$100*D$2:D$100)
where F2=Google; G2=Buy

Hope this helps

M.

Brilliant sir. Thank you.

 

[nycraja]

What if I wanted to just calculate the weighted average??

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.

 

[Marcelo Branco]

What if I wanted to just calculate the weighted average??

Try

=SUMPRODUCT(--(A$2:A$100=F2),--(B$2:B$100=G2),C$2:C$100*D$2:D$100)/SUMIFS(C$2:C$100,A$2:A$100,F2,B$2:B$100,G2)

M.

 

[nycraja]

Try

=SUMPRODUCT(--(A$2:A$100=F2),--(B$2:B$100=G2),C$2:C$100*D$2:D$100)/SUMIFS(C$2:C$100,A$2:A$100,F2,B$2:B$100,G2)

M.

You're brilliant. Million thanks!