Look at help on the SumIf Function

=sumif(C2:C10, A1, E2:E10)

--
HTH...

Jim Thomlinson


"Canon" wrote:

Excel 2007
I have a sheet with different values in column c, and different numbers in
column e. On a separate sheet, (cell A1) I would like to add up the values
that match the numbers.
ie. if any cell in column e = 2001, then add all the cells in column c that
are in the same row as the 2001 in column e.
i.e. colunm c column e
$25.00 2001
$75.00 2004
$50.00 2001
$45.00 2005
The total for the other sheet, (cell A1) should be $75.00, I would have to
repeat this formula for all the different numbers in column e.