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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!