You have multiple ways try the following create column F with the following formula =IF(E2="YES", E2, 0) Then drag it down till the end