Excel spread sheet overview tab formulas
3269
$$
- Posted:
- Proposals: 13
- Remote
- #740671
- Archived
Description
Experience Level: Intermediate
Hi,
I need the summary tab to be automatically added up and populated for each column. (i will add a new column per day and copy the formula over).
Each day a new spreadsheet is supplied with a list of unique names and quanties, i need to be able to create a summary tab that combines all data from other tabs into one simple and easy to view summary tab.
Formatting / presentation is not an issue, i just need the formulas adding in.
Not every item will be on the list every day - in the event of an item not being resent for that day na or - must be displayed (0 is not an acceptable value as the reason the item wont appear is the quantity is higher than the threshold). I have attached a version of this but i have changed the names for security.
I need the summary tab to be automatically added up and populated for each column. (i will add a new column per day and copy the formula over).
Each day a new spreadsheet is supplied with a list of unique names and quanties, i need to be able to create a summary tab that combines all data from other tabs into one simple and easy to view summary tab.
Formatting / presentation is not an issue, i just need the formulas adding in.
Not every item will be on the list every day - in the event of an item not being resent for that day na or - must be displayed (0 is not an acceptable value as the reason the item wont appear is the quantity is higher than the threshold). I have attached a version of this but i have changed the names for security.
Graeme H.
94% (14)Projects Completed
15
Freelancers worked with
12
Projects awarded
54%
Last project
2 Jan 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies