CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
Noob Master
Noob Master

Reputation: 37

How to find out sum of multiplication of 2 column based on value of a third column?

Silly Q, plz help I am trying to find of Total invested amount for open positions in my PF. which is like
sum( if(G3="","",D3xE3)+if(G4="","",D4xE4)+..+.........)

How to write a formula for the same.

Thanks.

enter image description here

Upvotes: 0

Views: 103

Answers (1)

Harun24hr
Harun24hr

Reputation: 36880

Try SUMPRODUCT() like-

=SUMPRODUCT(D3:D100,E3:E100,G3:G100="")

Upvotes: 1

Related Questions