Phoenix - Your AI AssistantCreate formulas in excel document to calculate total cost
- Posted:
- Proposals: 16
- Remote
- #3207142
- Awarded
Copenhagen 
Description
Experience Level: Entry
On the attached excel document there are 6 tabs, 3 material take-off lists, and then the same 3 lists are duplicated with costs shown instead of qtys.
On each of the tabs that include 'PRICED' within their name, I need to add a Total box, that calculates the qty of each item on tab A, multiplied by the cost in tab B.
E.g. on Tab 'List 01 PRICED' there should be a total cost box that adds up cell H21 on tab "List 01-Small" x cell H21 on tab "List 01 PRICED", and all the other yellow highlighted cells thereafter.
The intention is that I can enter my required qtys on tab A, which then generates a total purchase value on tab B.
The formulas will need to apply to all the other non-highlighted cells as well, so that if prices / qtys are added to these cells in the future, the formulas will still work and calculate the overall cost.
On each of the tabs that include 'PRICED' within their name, I need to add a Total box, that calculates the qty of each item on tab A, multiplied by the cost in tab B.
E.g. on Tab 'List 01 PRICED' there should be a total cost box that adds up cell H21 on tab "List 01-Small" x cell H21 on tab "List 01 PRICED", and all the other yellow highlighted cells thereafter.
The intention is that I can enter my required qtys on tab A, which then generates a total purchase value on tab B.
The formulas will need to apply to all the other non-highlighted cells as well, so that if prices / qtys are added to these cells in the future, the formulas will still work and calculate the overall cost.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
The attachment you say is not here. Glad to have an idea of what you need.
-
You said that you "attached excel documents " but there is no attachment, please provide the file for better understanding.