# Calculate the total amount base on status

edited 12/09/19

Hi,

As per attached screenshot, how can i calculate the total amount when status in RED?

• edited 03/07/18

Sorry first attempt was wrong. I think you need a hidden column where you place a simple IF statement that grabs the value IF the Status="Red" , else it drops in a 0 then you can just add them up with a =SUM and then copy that over to the origin column. =IF(Status3 = "Red", [down payment]3, 0).

In my image below you then sum the HIDEME column and in the payment column just grab the value from the hidden column. There's surely a slicker way to do it but will work quickly and easily.

Hideme formula: =IF(Status3 = "Red", payment3, 0)

Hideme column formula: =SUM(hideme3:hideme6)

Payment column formula: =hideme8

• ✭✭✭✭✭✭
edited 03/07/18

You can also use a Sumif formula.

=Sumif(status:status, "Red", payment:payment)

Would sum all of the payment cells where Red was in the status cell. No need to add hidden columns. Hope that helps!

https://help.smartsheet.com/function/sumif

• Way better solution thanks for the education Mike.

• ✭✭✭✭✭✭

Not a problem. Glad I could help!

• It work. thank you Mike.