Summing columns

[Dougie12.]

Hi I'm trying to find one formula that can sum up the data responding to another criteria and then insert a row to total that sum. See attached example explains this better.

Is it possible?

Thanks

[avk]

As per your data, you can do in "F2"

Please Login or Register  to view this content.

copy paste up to "F10"
In "F12"

Please Login or Register  to view this content.

copy paste up to "F16"
In "F18"

Please Login or Register  to view this content.

copy paste up to "F19"
In total use sum formula as per range.

[Dougie12.]

Hi

I'm sorry but I don't think you understand what I'm trying to achieve.

I dont think I explained it too well.

I attached the data A & B columns as the raw data and tried to explain what I want it to look like in columns E & F. The two sets of columns are not linked and shouldn't be, I just put them on the same spreadsheet so you can see how the data looks now and how I want it to look, so using IF $A = $E does not exist.

I've reattached the spreadsheet, I need the formula to work out and total each clients values if possible under the data (if not it doesn't really matter).

[FlameRetired]

The offset row labels are a challenge.

This is how I did it.

1. Using the first upload (post #1)
2. Select A2:A17.
3. Press Ctrl + G (or F5 function key)
4. Click 'Special...
5. Click 'Blanks'
6. Click OK
7. Type = followed by the up arrow key.
8. Hold down Ctrl while hitting enter.

That will complete the row labels.

Next:

1. Select A1:B17
2. Click DATA on the ribbon.
3. In the Outline group click Subtotal
4. Check only column B and Summary below data.
5. Click OK

There will be a Grand Total line which you can delete if you prefer.