K
keri
Hi,
I have a range presented like a table;
ID Cost1 Value1 Cost2
Value2 TotalCost TotalValue
1 50 80 60
90 110 170
5 2000 2200 1000
2300 3000 4500
1 20 40 40
60 60 100
3 10 20 10
20 20 40
2 150 180 160
190 310 370
I want to be able to total all of the values in each colum where the
ID is the same.
Eg. for ID 1 I would like to total all Cost1 values (in this case
return 70), and all value1 values (120). However I could have up to
500 different ID's.
I know how to do an if statement on one line - eg.
=if(a1="1",a2,"")
However I would have to do this on every row for every ID. Is there an
easier way?
I have a range presented like a table;
ID Cost1 Value1 Cost2
Value2 TotalCost TotalValue
1 50 80 60
90 110 170
5 2000 2200 1000
2300 3000 4500
1 20 40 40
60 60 100
3 10 20 10
20 20 40
2 150 180 160
190 310 370
I want to be able to total all of the values in each colum where the
ID is the same.
Eg. for ID 1 I would like to total all Cost1 values (in this case
return 70), and all value1 values (120). However I could have up to
500 different ID's.
I know how to do an if statement on one line - eg.
=if(a1="1",a2,"")
However I would have to do this on every row for every ID. Is there an
easier way?