Display MoreRe: SumIf cell is equal to any in a list
Assuming your data is in A1:B5 and the two division names are in E5:E6:
=SUMPRODUCT(SUMIF(A1:A5,E5:E6,B1:B5))
will do it.
Thanks so much, rory
Display MoreRe: SumIf cell is equal to any in a list
Assuming your data is in A1:B5 and the two division names are in E5:E6:
=SUMPRODUCT(SUMIF(A1:A5,E5:E6,B1:B5))
will do it.
Thanks so much, rory