SumIF with multi criteria

[vidplaylist]

I want to use sumif function to sum the sales of 3 branches out of total branches in one cell.

Can i put all three branches in Criteria.

I tried sumifs function but it's not workable because i want to sum the 3 criteria answer.

Thanks,

 

[Aladin Akyurek]

I want to use sumif function to sum the sales of 3 branches out of total branches in one cell.

Can i put all three branches in Criteria.

I tried sumifs function but it's not workable because i want to sum the 3 criteria answer.

Thanks,

Try something like...

=SUMPRODUCT(SUMIF(BranchRange,List,SumRange)

where List is a range housing the 3 branches of interest.

 

[vidplaylist]

=SUMPRODUCT(SUMIF(BranchRange,List,SumRange)

How to declare List for example Branch are A , B & C

 

[scottylad2]

Deleted

far more elegant answers already posted

 

[Aladin Akyurek]

=SUMPRODUCT(SUMIF(BranchRange,List,SumRange)

How to declare List for example Branch are A , B & C

Either create a range named List that houses A, B, and C or enter them directly in the formula:

=SUMPRODUCT(SUMIF(BranchRange,{"A","B","C"},SumRange))

 

[vidplaylist]

Worked. Bundle of thanks.

 

[Aladin Akyurek]

Worked. Bundle of thanks.

You are welcome. Thanks for providing feedback.