add up

[pazza101]

hi
i have a workbook with several lines on each page a need to add up some maybe zero some maybe negative or positve numbers

for example if we are 6 hours ahead i need to show we are that thought the easiest way would be +6 same if we are behind 6 hours -6 on time 0

thought this would be simple but for me it is not


thanks for any help/ideas you have

 

[Gerald Higgins]

Hi. I think it's pretty much impossible to answer a question as vague as your's.

Can you provide a little more detail please ?

What exactly does your data look like ?
Can you post a small sample of your data ?
What exactly do you want to do with your data ?

Don't worry too much about explaining the background to your situation, just focus on what data you have, and what you want to do with it.

 

[pazza101]

ok below i have the relation to plan box here i need to show a number depending on how we are doing against plan i put in the hours say if im in front i need to put in a figure same as behind or on time.

i then need to add all this up for each line running and send to a summary sheet showing how we are doing as a factory againt plan so say i add them all up for the whole week. they need to show exactly how far in front or behind.
so what im asking is how i could make this i easy to input the information and then show up on a summary sheet to show
all the info would need to show as either a positive or negative number below
[TABLE="width: 360"]
<colgroup><col style="width: 120pt; mso-width-source: userset; mso-width-alt: 5851;" width="160"> <col style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;" span="5" width="64"> <tbody>[TR]
[TD="class: xl66, width: 160, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 192, bgcolor: transparent, colspan: 3"]Unplanned Stop/changeover[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"]0[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent, colspan: 2"]Rel to plan weekly[/TD]
[TD="class: xl65, bgcolor: transparent"]hrs[/TD]
[TD="class: xl67, bgcolor: transparent"]0[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


rel to plan is where i would input each line eg 3 hrs ahead (i could just have a number) 3 or + 3 [TABLE="width: 472"]
<colgroup><col style="width: 126pt; mso-width-source: userset; mso-width-alt: 6144;" width="168"> <col style="width: 84pt; mso-width-source: userset; mso-width-alt: 4096;" width="112"> <col style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;" width="114"> <col style="width: 95pt; mso-width-source: userset; mso-width-alt: 4608;" width="126"> <col style="width: 81pt; mso-width-source: userset; mso-width-alt: 3949;" width="108"> <tbody>[TR]
[TD="class: xl67, width: 168, bgcolor: transparent"]PERFORMANCE[/TD]
[TD="class: xl68, width: 112, bgcolor: transparent"]Eff %[/TD]
[TD="class: xl68, width: 114, bgcolor: transparent"]Waste (kg)[/TD]
[TD="class: xl67, width: 126, bgcolor: transparent"]Rel to Plan (hrs)[/TD]
[TD="class: xl67, width: 108, bgcolor: transparent"]Ongoing issues[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Muffin1[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl74, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Muffin2[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl72, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Muffin3 [/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl72, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Asser[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl72, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Gouet 5[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Garlic Baguettes[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl72, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Meca C[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Meca D[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl72, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Garlic Slices[/TD]
[TD="class: xl75, bgcolor: transparent"]0%[/TD]
[TD="class: xl73, bgcolor: transparent"]0[/TD]
[TD="class: xl69, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Gerald Higgins]

Sorry, I've read and re-read this but I just don't understand what you want to do.

Anyone else have a clue ?

 

[pazza101]

in the bottom the rel to hours i find out if im in front or behind or even on time put the number in to show that eg 2 hrs ahead i put in +2 behind 2hrs i put in -2.

what i need to do is transfer this info to the front page of the workbook to show in total if we are infront or behind by adding all of them together

rel to plan hrs
+2
0
-3
+5 would = +4
but i could i show this on a front summary page it needs to show how many hrs and if we are infront or behind