Excel Excel Query

J

Joey

Joined
Aug 18, 2007
Messages
1
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtracting multiple columns from another column 3
Excel Help with dates 2
Excel Excel 2007/2010 Duplicates Entries in Four Columns of Data 7
SUM - IF - AND 7
Excel Countifs/Sumproduct with mutil Or statement 3
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4
Excel Concatenate with line breaks but ignore blank cells 3
Scrabble Value calculation for Welsh words 0

Top