Hello
Apologies if this has been answered in another thread, I have tried to ask the question in many different ways but cannot come up with anything that helps.
I have several columns of data regarding damages that contain Date;Item;Volume;Reasons Code in one sheet.
I am trying to define trends.
I am trying to check that if a particular item, in a particular month shows in a table, then the total volume (for that item in that month)is then added together and put into a a column in another sheet.
Eg
Sheet one looks like this (i HAVE ONLY INCLUDED 3 ITEMS - IN REALITY IT WILL BE APAPROX 10)
sheet 1
MONTH....... ITEM.. ........VOLUME... ....REASON AUG... white tin........... 13.... MISC (PLEASE ADVISE)
AUG... red tin 9 WATER INGRESS
AUG... white tin 60 WATER INGRESS
AUG blue tin 5 MISC (PLEASE ADVISE)
SEPT blue tin 83 MISC (PLEASE ADVISE)
SEPT blue tin 63 WATER INGRESS
SEPT red tin 132 MISC (PLEASE ADVISE)
OCT white tin 51 MISC (PLEASE ADVISE)
OCT red tin 45 WATER INGRESS
OCT white tin 8 WATER INGRESS
Sheet 2 (if I could manage the formula!) would look like this
sheet 2
Month ...white red blue aug...... 73 .....9....5
sep....... 0.....132....146
oct.......59..... 45....0
I can then chart the trends across several month(if there are any)
I can chart trends no problem, it's the actual formula to pick up the info that I am struggling with
hOW DID YOU GET THE MONTH VOLUME TO ACCUMULATE (ie I have several entries for Aug but it your chart it is aded together - when I do it I get individual totals for each entry for aug - making the chart look busy - your chart is exactlyhow i want it to look)
