CODEWITHSUNDEEP
criterialibreoffice-calc
Donald Chun
Donald Chun

Reputation: 3

how to use sumif to match multiple criteria on same range

how to use sumif to sum up multiple criteria on same range?

i use the formula =sumif(C3:C7,{"A","B","C"},D3:D7), it was able to sum-up only "A". Even through =sum(sumif(C3:C7,{"A","B","C"},D3:D7)) does not work as well as shown in this screenshot screenshot

Upvotes: 0

Views: 752

Answers (1)

JohnSUN
JohnSUN

Reputation: 2529

Try

=SUMIF(C3:C7;"A";D3:D7)+SUMIF(C3:C7;"B";D3:D7) +SUMIF(C3:C7;"C";D3:D7)

or

=SUMPRODUCT(SUMIF(C3:C7;{"A";"B";"C"};D3:D7))

or

=SUMPRODUCT(D3:D7;(C3:C7="A")+(C3:C7="B")+(C3:C7="C"))

Upvotes: 2

Related Questions