Help to create a formula that sums a column based on if values in two other colums are correct.

Hugo Martinwall

Hello,

 

I have three columns that need to be in a formula.

TIME, Y, Z

I Want to SUM all the rows under the "TIME" column based on if the Y and Z columns have the specific dropdown value.

This was my try but it did not work: =SUMIFS([Z]:[Z]; "Approved"; [Y]:[Y], "", Time:Time)

Can anyone help?

 

Kind Regards,

Hugo Martinwall

Andrée Starå

Hi (Hej < Swedish for Hello) Hugo,

Try this.

You've mixed up the order. The first part in a SUMIFS formula is the range to sum if all criteria are true.

=SUMIFS(TIME:TIME; Z:Z; "Approved"; Y:Y; "")    

The same version but with the below changes for your and others convenience.   =SUMIFS(TIME:TIME, Z:Z, "Approved", Y:Y, "")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting