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?