Formula To Add Columns that Contain a Value

Biiams

Hey All,

I am creating a training matrix and need help with a formula for the "Total Trainings Completed" column. Each training (1,2,3,4, etc.) will be its own column and based on where the employee is at in the training a number value will be entered in that columns cell ( 0= not started, 1 = in process, 2= trained, 3 = seasoned, 4=trainer). I need the total trainings completed to count each column as a value of 1 if the value entered in the cell is >1. So for example I need Joe Smiths Total Trainings Completed to equal 2 ( 2 of the 4 trainings have been completed).

AravindGP

Hi @Biiams

You can use this formula in the Total Trainings Completed column

=COUNTIF([Training 1]@row:[Training 4]@row, >1)