I'm not sure whether I'm using the correct function etc....Can anyone help?
I have a table laid out as follows. It contain multiple entries of items in Column A.
Column A Column B Column C Column D
Item ID ID ID
A 4 4 4
A 6 4 2
B 10 10 10
C 10 10 10
D 2 2 2
I then have a consolidated table in which I want to sum the totals of items A - D, but grouped by Column ID, i.e. If the Column ID's for A & B were the same, then the figure returned for Item A would be 18, if the ID's for columns A - C were the same, 24 would be returned.
Ay suggestions anyone?
I have a table laid out as follows. It contain multiple entries of items in Column A.
Column A Column B Column C Column D
Item ID ID ID
A 4 4 4
A 6 4 2
B 10 10 10
C 10 10 10
D 2 2 2
I then have a consolidated table in which I want to sum the totals of items A - D, but grouped by Column ID, i.e. If the Column ID's for A & B were the same, then the figure returned for Item A would be 18, if the ID's for columns A - C were the same, 24 would be returned.
Ay suggestions anyone?