Creating a running total of different sectors from one sheet.

Hi - I need some help!

I need to create running totals for each year of the Contract Values for each Sector that my Company deals with.
There are 5 Sectors - C, M, W, WW and WtoE. Each possible contract has its own Contract Value.

For eg -

Sector Contract Value

W € 36,779.33
WW € 20,325.20
W € 246.14
W € 2,168.40
WW € 176,617.00
W € 320.65
M € 28,620.00
WW € 18,239.94
W € 8,866.80
WW € 9,000.00
W € 5,892.05
WW € 432.00
W € 43,225.93
W € 6,654.09
M € 438.96
WW € 15,214.50
WW € 2,064.25
WtoE € 17,822
C € 10,983.24


In the whole document we have previous year's contracts too - but I want to create running totals for each year - i.e. for 2010, 2011, 2012, 2013, 2014. How could I separate these easily?

Obviously the total depends on which sector we are looking at - I thought about using the IF formula - but realised that there would be a lot of IF's - is there an easier way of doing it? If not - what's the best way?

Thank you for your help!

You very kindly provide some sample data - but with no indication of the year for which these figures apply.

How is your document organized?
Is there a separate sheet for each year?
Are all the years in the same worksheet (in which case, how do you indicate the year)?
A running total imples that there is some sort of 'movement' (typically down a list of entries, with the running total representing "the sum up to this point". What is the implied 'movement' in your document?

These are (admittedly) nit-picking questions, but it is by identifying and harvesting nits that we can help you construct a nest

HTH - look forward to hearing back!

Tony

The sheet is called Product Register

Doesn't work - asks me to open a file

Kristy

Would you attach a small spreadsheet showing us the data that you have to work with. Then we'll all be starting from a secure foundation!

Thanks,

Tony

Contract Sector Totals.xlsx

The columns highlighted yellow are the contract date, sector and contract value.

Thanks, Kristy!

So you want a summary crosstab on the separate sheet with Equipment type/Sector against Year, as a kind of dashboard showing performance to date. Is this right?

Tony

I need a summary of the Total Contract Valuefor each Sector within the relevant year.
on a separate sheet yes

Mind boggling!

The first part works - not the second.

I think the pivot table may work the best - but I'm having some problems getting the information I want on to it?

Hard to tell if the problem is solved, since the last post seems to be a concern!

However, take a lok at this. I had to be away from my desk for a couple of days, but I got a chance to finish up a dashboard type thing for you.

It adapts to any number of rows in the Datasheet, and gives you count and total contract value for the periods in the datasheet.
Only thing it doesn't do is determine the Years to report, and the Groups to report, but that would be an easy set-up function.

HTH

Tony