Formula for Percentile of Total Sheets

[canadacheesehead]

As I sit here getting ready to ask questions on what I'm needing help with, I find myself lost and not sure about terminology. So I'll just K.I.S.S it.

1 excel file

25 tabs or worksheets

each work sheets has 20 lines of information on 20 pallets

so the total number of pallets would be 500 pallets = 100%

I'm trying to get a formula that will give me a running % full over all the sheets.

I've already have a formula for total number of blocks on each pallet

Here are some screen shots. Thanks for the input

Screen Shot 2017-06-05 at 10.06.07 PM.png

[DannyJ]

I don't understand what you are trying to do.


Please de-sensitize the spreadsheet and post it.

To do this:

Click
'Go Advanced'
'Manage Attachments'

Choose the file you need to attached.

[canadacheesehead]

Email me at mushenskij@yahoo.com and I'll forward you a copy if you don't mind.


QUOTE=DannyJ;4670593]I don't understand what you are trying to do.


Please de-sensitize the spreadsheet and post it.

To do this:

Click
'Go Advanced'
'Manage Attachments'

Choose the file you need to attached.[/QUOTE]