Jump to content

Which Table Formula will work to achieve this result?

Recommended Posts



I have about 50 blocks and each contain manuf. nos. The Data Extraction program is utilized which links these blocks to an excel spreadsheet to extract desc. & unit. to extract this data and placed in a bill of material together with the correct quantity calculated by this template.

I have approximately 10 typical manuf. nos. that exist in various blocks. For example, manuf. No. "A123" will be in block "A", "G" and "M". The total quantity of this particular manuf no. is correctly calculated and placed in the bill of material. However, these manuf. no’s. quantity needs to be further divided by a “y” amount, and in the end needs to be rounded to the nearest 1 and placed on the quantity column.

Can you please let me know which Table formula will work to achieve this result?

Thank you.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...