Balance Sheet Formula
Hi,
I assume your values are in sheet 1 and the summary in sheet 2
in column A sheet 2 you have the years and in column B you want the total
amount so enter
=sumproduct(--(A2=sheet1!$E$1:$E$10000),sheet1!$C$1:$C$10000)
change range to fit your needs, remember range has to be the same in both
sides of the formula
"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.
|