# Formula To Add Columns that Contain a Value

✭✭✭✭

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).

## Answers

• ✭✭✭✭✭✭

Hi @Biiams

You can use this formula in the Total Trainings Completed column

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

Thanks,

Aravind GP| Principal Consultant

Atturra Data & Integration

M: +61493337445

E:Aravind.GP@atturra.com

W: www.atturra.com

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!