Adding two or more cells in the same column according to date

Mrsnic

Hello,

I have multiple cells in one column, which are numbers, with the same date and I would like to combine the figures into one cell, with the date in an adjacent column.

Combine the two Manpower Daily entries for 19/5/25 into one entry in the Project Manpower column.

I've tried a few formulas and nothing seems to work.

Any ideas/solutions are welcome. Thank you.

Gia Thinh

Hello @Mrsnic

Try the solution below:

1- Add an ID helper column, with auto-number property

2- Project Manpower column : column formula :
=IF(AND(ID@row = MIN(COLLECT(ID:ID, Date:Date, Date@row )), Date@row <> ""), SUMIFS([Manpower Quantity Daily Total]:[Manpower Quantity Daily Total], Date:Date, Date@row ))

If you want the total is at the last same-day row, then use this formula:

=IF(AND(ID@row = MAX(COLLECT(ID:ID, Date:Date, Date@row )), Date@row <> ""), SUMIFS([Manpower Quantity Daily Total]:[Manpower Quantity Daily Total], Date:Date, Date@row ))

Hope it works for you.

Gia Thinh

Hello @Mrsnic

Try the solution below:

1- Add an ID helper column, with auto-number property

2- Project Manpower column : column formula :
=IF(AND(ID@row = MIN(COLLECT(ID:ID, Date:Date, Date@row )), Date@row <> ""), SUMIFS([Manpower Quantity Daily Total]:[Manpower Quantity Daily Total], Date:Date, Date@row ))

If you want the total is at the last same-day row, then use this formula:

=IF(AND(ID@row = MAX(COLLECT(ID:ID, Date:Date, Date@row )), Date@row <> ""), SUMIFS([Manpower Quantity Daily Total]:[Manpower Quantity Daily Total], Date:Date, Date@row ))

Hope it works for you.

Mrsnic

That worked perfectly. Just what I needed.

Thank you so much.