V
vtisix
I am looking for a way to shorten multiple SUMIF formulas, i.e. column A contains reference #s, column B contains values. Currently if I am looking to sum multiple values in column A, I use the following:
=SUMIF(A:A,"=Black",B:B) + SUMIF(A:A,"=Yellow",B:B) + SUMIF().....
As you can see, this can get really cumbersome to work with if I am looking for 4 or more conditions. I am looking for a way to do the following (in principle):
=SUMIF(A:A,"Condition 1"; "Condition 2"; "Condition 3"....,B:B)
The formula basically goes into column A, finds all the conditions and sums up corresponding values in column B.
I have dabbled with the SUMPRODUCT fomula, ie.
=SUMPRODUCT(--(A1:A60000="Black"),--(A1:A60000="Yellow"),B1:B60000) - this returns #NUM error.
Any thoughts? This has been driving me bonkers for the last couple of days. Any help is much appreciated.
Thanks,
VT
=SUMIF(A:A,"=Black",B:B) + SUMIF(A:A,"=Yellow",B:B) + SUMIF().....
As you can see, this can get really cumbersome to work with if I am looking for 4 or more conditions. I am looking for a way to do the following (in principle):
=SUMIF(A:A,"Condition 1"; "Condition 2"; "Condition 3"....,B:B)
The formula basically goes into column A, finds all the conditions and sums up corresponding values in column B.
I have dabbled with the SUMPRODUCT fomula, ie.
=SUMPRODUCT(--(A1:A60000="Black"),--(A1:A60000="Yellow"),B1:B60000) - this returns #NUM error.
Any thoughts? This has been driving me bonkers for the last couple of days. Any help is much appreciated.
Thanks,
VT