Hi there,

Difficult task for me but not for some of you out there I guess...

I have a spreadsheet that is made up of 5 worksheets;

1. Worksheet 'Percentages' H19 this is where the formula that I seek will
reside!

2. Worksheet 'Small Parts' contains 2 separate cells [F3 & L3] that each
contain a number that have to be added together and entered into the above
'Percentages' H19

3. Worksheet 'Quality Critical Parts' also contain 2 separate cells as above
[F3 & L3] that each contain a number that has to be added to the number
obtained in 2. above as a sort of running total and entered into
'Percentages' H19

3. Worksheet 'Tools' again contains 2 separate cells [D3 & D23] that contain
a number that has to be added together and then added to the running total
already in 'Percentages' H19

4. Worksheet 'Other' contains a further 2 separate cells [F3 & F26] that
once again each contain a number that has to be added together and then
added to the running total in 'Percentages' H19 above.


For example;

Small Parts [F3=1] [L3=1]
These are added together to give [2] and this result is displayed in
Percentages H19

Quality Critical Parts [F3=2] [L3=2]
These are added together to give [4] and this new result [6] is displayed in
Percentages H19

Tools [D3=5] [D23=5]
Added together gives [10] this together with the result above [6] gives [16]
now displayed in Percentages H19

Other [F3=10] [F26=10]
Added together gives [20] which is then added to [16] above to result in
[36] now displayed in Percentages H19


Now the formula below seems to work but is there a 'better', quicker, more
efficient or 'recognized' way of achieving the same result?

=SUM(Small Parts!F3+Small Parts!L3+Quality Critical Parts!F3+Quality
Critical Parts!L3+Tools!D3+Tools!D23+Other!F3+Other!F26)

--
Regards,
-pp-

You could sub-total on each worksheet - this would tidy-up your final
formula - but the bottom line is you can't add up a number of cells
unless you identify them!

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504328