# SUMIFS to total product A and B

1. ## SUMIFS to total product A and B

Guten Tag!

I have attached a spreadsheet. I have 4 products - A, B, C, and D, along with how many units of them were made.
I have no problem automatically summing up "units made" for each individual product, however, I AM having trouble using SUMIFS to sum "units made" for both A and B in the same cell.

=SUMIFS(units made column,product type column, can be A or B)

Any ideas would be appreciated.

2. ## Re: SUMIFS to total product A and B

i do not know how to accomplish this with SUMIFS (in the fashion you have depicted), may be an expert can assist. with SUMPRODUCT, it is a breeze:

in cell I3:

=SUMPRODUCT((\$A\$2:\$A\$12="a")+(\$A\$2:\$A\$12="b"),\$B\$2:\$B\$12)

3. ## Re: SUMIFS to total product A and B

Hi Mike,

Why don't you combine both SumIFs for A and B to get the result as 254..

Regards,
DILIPandey

<click on below 'star' if this helps>

4. ## Re: SUMIFS to total product A and B

Like this

=SUM(SUMIF(\$A\$2:\$A\$12,"A",\$B\$2:\$B\$12),SUMIF(\$A\$2:\$A\$12,"B",\$B\$2:\$B\$12))
and
=SUM(SUMIF(\$A\$2:\$A\$12,"C",\$B\$2:\$B\$12),SUMIF(\$A\$2:\$A\$12,"D",\$B\$2:\$B\$12))

5. ## Re: SUMIFS to total product A and B

Thanks! That should work.

6. ## Re: SUMIFS to total product A and B

You're welcome. Thanks for the 'star tap'.

There are currently 1 users browsing this thread. (0 members and 1 guests)