SUMIFS, one criteria range, multiple criteria
"GavinS" wrote:
I would like to sum items in column A where column
B = B or C (I think these are numbers stored as text).
I cannot get SUMIFS to work with multiple criteria
=SUMIFS(A1:A100,B1:B100,"B")+SUMIFS(A1:A100,B1:B10 0,"C")
or
=SUMIF(B1:B100,"B",A1:A100)+SUMIF(B1:B100,"C",A1:A 100)
or
=SUMPRODUCT(A1:A100,--(B1:B100={"B","C"}))
|