Skip to main content
How to calculate a daily cost
Erin Clazie avatar
Written by Erin Clazie
Updated over 5 months ago

Calculating a daily cost

To calculate a daily cost, you might want to SUM values from multiple tables eg. internal labour, external labour, plant, and materials.

In this example, the formula references three tables (Table1, Table2 and Table3), and sums all the values in the A column from each table to arrive at a total.

=SUM(Table1!A:A)+SUM(Table2!A:A)+SUM(Table3!A:A)
Did this answer your question?