Sum only the latest value

Julio C. Alvarez

Hello,

I have a sheet that updates values of a certain id through a form. 

I want to add the last values of each id.

Thank you

Ramzi K

@Julio C. Alvarez

Here's one way to do it.

Add a helper column called MaxValue with this formula:

=IF(Date@row = MAX(COLLECT(Date:Date, ID:ID, ID@row)), Value@row)

Then your sum formula will be: =SUM(MaxValue:MaxValue)

I hope this helps.

Cheers,

Ramzi

Ramzi K

@Julio C. Alvarez

Here's one way to do it.

Add a helper column called MaxValue with this formula:

=IF(Date@row = MAX(COLLECT(Date:Date, ID:ID, ID@row)), Value@row)

Then your sum formula will be: =SUM(MaxValue:MaxValue)

I hope this helps.

Cheers,

Ramzi

Julio C. Alvarez

Great!! Thank you Ramzi