Prev: PLEASE HELP
Next: Which function will shorten IF-THEN-ELSE ?
From: Tom on 17 May 2010 22:47
Have a column for item id and a column for its Qty. What I need to do is have
a sum of all the item id quanitities whose item id is either a 1, a 3, or a
7. If it was just that I needed the sum of those with 1 I could use SumIf.
But what if I want a combined total of certain id's?
From: T. Valko on 17 May 2010 22:59
One way...

=SUM(SUMIF(A2:A100,{1,3,7},B2:B100))

--
Biff
Microsoft Excel MVP


"Tom" <Tom(a)discussions.microsoft.com> wrote in message
news:A42C1C77-42AE-449E-94CB-8854E759F746(a)microsoft.com...
> Have a column for item id and a column for its Qty. What I need to do is
> have
> a sum of all the item id quanitities whose item id is either a 1, a 3, or
> a
> 7. If it was just that I needed the sum of those with 1 I could use SumIf.
> But what if I want a combined total of certain id's?


From: trip_to_tokyo on 17 May 2010 22:59
On May 18, 4:47 am, Tom <T...(a)discussions.microsoft.com> wrote:
> Have a column for item id and a column for its Qty. What I need to do is have
> a sum of all the item id quanitities whose item id is either a 1, a 3, or a
> 7. If it was just that I needed the sum of those with 1 I could use SumIf..
> But what if I want a combined total of certain id's?

Hi Tom, you could do this with a Pivot Table if you wanted to.

Please check out:-

http://www.pierrefondes.com/

Item 108.

If you pull that up on the screen in front of you it can easily be
applied to your example.

Just click in H 2 and choose the Acct Number's (your id) you want to
include / exclude.

If my comments have helped please hit Yes.

Thanks.


From: ozgrid.com on 17 May 2010 23:04
Use SUMIFs if you have 2007

If not, try;
=SUM(SUMIF($A$1:$A$10,1,$B$1:$B$10),
SUMIF($A$1:$A$10,2,$B$1:$B$10),
SUMIF($A$1:$A$10,3,$B$1:$B$10))


Other ways here
http://www.ozgrid.com/Excel/sum-if.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Tom" <Tom(a)discussions.microsoft.com> wrote in message
news:A42C1C77-42AE-449E-94CB-8854E759F746(a)microsoft.com...
> Have a column for item id and a column for its Qty. What I need to do is
> have
> a sum of all the item id quanitities whose item id is either a 1, a 3, or
> a
> 7. If it was just that I needed the sum of those with 1 I could use SumIf.
> But what if I want a combined total of certain id's?

 | 
Pages: 1
Prev: PLEASE HELP
Next: Which function will shorten IF-THEN-ELSE ?