Hi
The general solution to your request is
=SUMIF(Sheet1!E:E,2001,Sheet1!C:C)
Rather than using 2001, on sheet2 place 2001 in say B1, 2002 in C1 etc then
in B2 of Sheet2 enter
=SUMIF(Sheet1!E:E,B1,Sheet1!C:C)
and copy across as required
--
Regards
Roger Govier
"Canon" wrote in message
...
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.
__________ Information from ESET Smart Security, version of virus
signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com
__________ Information from ESET Smart Security, version of virus signature database 4751 (20100107) __________
The message was checked by ESET Smart Security.
http://www.eset.com