user1046016
user1046016

Reputation: 171

SumIf formula in Excel with multiple conditions

Apologies for the seemingly basic Excel question - I have tried Google but can't quite find anything about this!

All I want to do is do a sum of a column based if the corresponding column before that fits into certain criteria.

For example, if I have:

    Column A   Column B
    YY            20
    ZZ            4
    TT            8
    UU            15

In a seperate cell, I want to sum up Column B where Column A is YY AND TT

How would I do this?

Upvotes: 2

Views: 633

Answers (1)

lori_m
lori_m

Reputation: 5567

 =SUM(SUMIF(A:A,{"YY","TT"},B:B))

Upvotes: 5

Related Questions