Collecting data from two different tables that needs to meet the same criteria.

Question

Level 1

4 points

Collecting data from two different tables that needs to meet the same criteria.

I need to add Overtime hours (table: Sign in (weekdays)) with Hours (Table: Sign in (Sunday and holidays)) to Total Overtime Hours and holidays. Both of them need to match the name of the Employee as criteria. I succeeded in writing a formula for one of the tables but I don't know how to add the secend one to the formula.

For example, in cell D2 (Summary) it needs to say 3h because Teo worked 1h overtime and 2h on Sunday.

MacBook Pro 13″, macOS 12.5

Posted on Aug 27, 2022 6:51 AM

Reply

Answer 1

Top-ranking reply

chuckbl

Community Specialist

Aug 28, 2022 8:21 AM in response to Teo662

Hello Teo662,

You should be able to use the + operator to add a secondary SUMIF function to your formula for the third table Sign in (Sunday and holidays).

This resource has more details on the + operator for reference: Calculate values using data in table cells in Numbers on Mac - Apple Support

Hopefully that addresses your inquiry.

Take care.

Reply

Answer 2

Badunit

Level 7

30,384 points

Aug 28, 2022 8:41 AM in response to Teo662

It looks like you are already close to the formula. I did not test the formula below but I think it is what you are asking. You may not be able to copy/paste it from here because of the table names and "headers used as labels".

=DURATION(0)+SUMIF(Sign in (weekdays)::A;A;Overtime Hours)+SUMIF(Sign in (Sunday and holidays)::A;A;Hours)

Reply