CODEWITHSUNDEEP
excelexcel-formulasumifs
Derik002
Derik002

Reputation: 175

How to sumif a row?

My table looks like this

Month     January    February
Apple       50           50
Orange      10           10
Grapes      5             5

When I try to sumif Apple like =sumif(A2:A4,"Apple",B2:C4) it only gives me 50 from January and not the whole line. The answer I need is 100.

How should I edit the formula?

Upvotes: 1

Views: 3667

Answers (1)

P.b
P.b

Reputation: 11483

Use SUMPRODUCT instead: =SUMPRODUCT((A2:A4="Apple")*B2:C4)

Upvotes: 1

Related Questions