Rollup data from another table?

Try this:

Main:: H2: SUMIFS(Material::M,Material::D,B2,Material::E,C2)

Assuming the Labour and Travel tables have the same construction, the formula will be the same for I2 and J2 except for the table name.

I2: SUMIFS(Labour::M,Labour::D,B2,Labour::E,C2)

J2: SUMIFS(Travel::M,Travel::D,B2,Travel::E,C2)

Fill all three formulas down fro row 2 to the last row in the Main table.

Regards,

Barry

you need to look at SUMIF or SUMIFS.

they would be able to sum values in the other tables, based on your project number listed in the master table.

You can find nice documentation on their use in the PDF provided by apple.

pages 197 and 198

Jason

for the table "Projects-Main View"

select cell H2, then type (or copy and paste from here) the formula:

=SUMIFS(Material::M, Material::B, D, Material::C, E, Material::A, C)

This will sum up the "Item Sub-total" where the Airport, Site and Project match 

Your formula might look something like this:

The formula in H2, of the example, filled down:

=SUMIFS(Material::E,Material::B,A2,Material::D,C2)

SG

Corinne-

It looks as if you could benefit from using SUMIFS (notice the S on the end of SUMIF).

Another function for aggregating is the COUNT series. You might consider checking them out.

Good luck.

can you post screenshots of what you have?

take a look at this User tip:

https://discussions.apple.com/docs/DOC-6591

"I've tried SUMIFS, but it says both ranges have to be the same size."

This means that the range containing the numbers to be summed must be the same size as the ranges containing each of the conditions to be tested.

Regards,

Barry