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.
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)
Last edited by icestationzbra; 05-26-2012 at 12:40 AM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
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>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
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))
Thanks! That should work.
You're welcome. Thanks for the 'star tap'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks