CODEWITHSUNDEEP
google-sheets
iamthe202
iamthe202

Reputation: 39

Multiply and Sum results if cells match criteria

I would like to multiply A:A*B:B whenever C:C = "Open", then sum their results when there's more than one "Open" in column C, and leave the cell blank when there's no "Open" in column C.

Here's the link to the sheet: https://docs.google.com/spreadsheets/d/1BgYcRx6-Ig3AkRNURr2-5Wz3vX5qG4J7SvHt8FlqrHw/edit?usp=sharing

Thanks.

Upvotes: 0

Views: 818

Answers (1)

basic
basic

Reputation: 11968

You can use SUM:

=ArrayFormula(SUM(A2:A*B2:B*(C2:C="Open")))

or SUMPRODUCT:

=SUMPRODUCT(A2:A*B2:B*(C2:C="Open"))

enter image description here

Upvotes: 2

Related Questions