Excel help, quickly summing object values over years.?

Question

I have a column of objects labeled U1 - U129. Every year the objects have attained a new value. I want to see what is the sum of the value for each 'U number' over the last 6 years. Is there a quick way of doing this? This is the lay out so far:

Year....Unumbers..Values......

2002.....U1.............50

............U2.............65

............U3.............23

...(up to U129)

2003.....U1.............24

............U2.............06

............U3.............58

.....(up to U129)

2003 etc........

Ideally it would create a table at the end displaying 129 U number's next to a column of the summation of the values of the 6 years I am looking at. Hope this makes sense? Thanks very much.

Answer 1

a couple of ways.  One way would be to use the Pivot Table feature.

another way would be to use SUMIF

with sumif you could enter a formula of

=SUMIF(B1:C1000, "U1", C1:C1000)

adjust the ranges above as needed.

this will sum up all the U1 entries in your range.  Then just create the same formula for U2, U3, etc.

the basic syntax of the sumif is

SUMIF(<range of your data>, <criteria>, <range you want summed>)