ANTONIO1981
Board Regular
- Joined
- Apr 21, 2014
- Messages
- 162
HI all
I'm looking for a formulae to calculate the total costs in "tab numbers"
it needs to sum the costs of all sites (for example water) in a month:
the volume in each site (tab volumes_table) multiplied by the cost each site
(tab variable cost_table)
example of one site only
(AT1 Volume in january= 4702.6)*(cost of water in AT1 In january=0.167) =785.33
the link will help to understand
question mr excel 2.xlsx - Google Drive
thanks in advance
Anthony
I'm looking for a formulae to calculate the total costs in "tab numbers"
it needs to sum the costs of all sites (for example water) in a month:
the volume in each site (tab volumes_table) multiplied by the cost each site
(tab variable cost_table)
example of one site only
(AT1 Volume in january= 4702.6)*(cost of water in AT1 In january=0.167) =785.33
the link will help to understand
question mr excel 2.xlsx - Google Drive
thanks in advance
Anthony