Conditional Addition
 

Howdy All,

Here is what I have:

Box inventory worksheet:

Column A = Box number
Column B = Box inventory description
Column C = Quantity of Column B

I want to find the total quantity for each box (regardless of Column B)

Example:

A1=1, B1=[description], C1=3499
A2=1, B2=[description], C2=1238
A3=2, B3=[description], C3=382
A4=2, B4=[description], C4=4322
A5=3, B5=[description], C4=3882


Total quantity of Box 1 = 3499+1238
Total quantity of Box 2 = 1238+382
Etc.

Any ideas?

Conditional Addition
 

Try this:

=SUMIF(A1:A5,E1,C1:C5)

where E1 is a cell where you can enter the box number - 1 or 2 or 3
etc.

Hope this helps.

Pete

Brian wrote:
Howdy All,

Here is what I have:

Box inventory worksheet:

Column A = Box number
Column B = Box inventory description
Column C = Quantity of Column B

I want to find the total quantity for each box (regardless of Column B)

Example:

A1=1, B1=[description], C1=3499
A2=1, B2=[description], C2=1238
A3=2, B3=[description], C3=382
A4=2, B4=[description], C4=4322
A5=3, B5=[description], C4=3882


Total quantity of Box 1 = 3499+1238
Total quantity of Box 2 = 1238+382
Etc.

Any ideas?

Conditional Addition
 

A couple of ways you might like.

A - WITH SUBTOTALS
1) sort by column A ascending
2) data subtotals. At each change in column A, use function SUM, add to
column C.
3) You will now have a subtotalled list and you can go to the 2nd group
level on the left and see the totals for each group.

B - SIMPLE SUMIF

use this formula in a cell somewhe

=SUMIF(A1:A5,1,C1:C5)
The 1 is the box number you are trying to get. Change that to 2 if you
want, or use a cell reference, where the cell has got the number of the box
in it. If you have more columns, then use A1:A197 and C1:C197, for example.

--
Allllen


"Brian" wrote:

Howdy All,

Here is what I have:

Box inventory worksheet:

Column A = Box number
Column B = Box inventory description
Column C = Quantity of Column B

I want to find the total quantity for each box (regardless of Column B)

Example:

A1=1, B1=[description], C1=3499
A2=1, B2=[description], C2=1238
A3=2, B3=[description], C3=382
A4=2, B4=[description], C4=4322
A5=3, B5=[description], C4=3882 ??? C5 surely


Total quantity of Box 1 = 3499+1238
Total quantity of Box 2 = 1238+382 ??? do you mean 382 + 4322?
Etc.

Any ideas?

Conditional Addition
 

=SUMPRODUCT(--(A2:A100=<boxnumber),(C2:C100))

Substitute <boxnunber for a cell containing box number

HTH

"Brian" wrote:

Howdy All,

Here is what I have:

Box inventory worksheet:

Column A = Box number
Column B = Box inventory description
Column C = Quantity of Column B

I want to find the total quantity for each box (regardless of Column B)

Example:

A1=1, B1=[description], C1=3499
A2=1, B2=[description], C2=1238
A3=2, B3=[description], C3=382
A4=2, B4=[description], C4=4322
A5=3, B5=[description], C4=3882


Total quantity of Box 1 = 3499+1238
Total quantity of Box 2 = 1238+382
Etc.

Any ideas?

Conditional Addition
 

To sum all the C values for which A =1 use =SUMIF(A1:A100,1,C1:C100)

Or make a Pivot Table

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Brian" wrote in message
...
Howdy All,

Here is what I have:

Box inventory worksheet:

Column A = Box number
Column B = Box inventory description
Column C = Quantity of Column B

I want to find the total quantity for each box (regardless of Column B)

Example:

A1=1, B1=[description], C1=3499
A2=1, B2=[description], C2=1238
A3=2, B3=[description], C3=382
A4=2, B4=[description], C4=4322
A5=3, B5=[description], C4=3882


Total quantity of Box 1 = 3499+1238
Total quantity of Box 2 = 1238+382
Etc.

Any ideas?

Thanks Everyone! got it
 

Thanks to ALL for the input.
"Brian" wrote in message
...
Howdy All,

Here is what I have:

Box inventory worksheet:

Column A = Box number
Column B = Box inventory description
Column C = Quantity of Column B

I want to find the total quantity for each box (regardless of Column B)

Example:

A1=1, B1=[description], C1=3499
A2=1, B2=[description], C2=1238
A3=2, B3=[description], C3=382
A4=2, B4=[description], C4=4322
A5=3, B5=[description], C4=3882


Total quantity of Box 1 = 3499+1238
Total quantity of Box 2 = 1238+382
Etc.

Any ideas?