Counting Number of columns with a value

Donna Rowett
Donna Rowett ✭
in Formulas and Functions

I am building a sheet that is a high level resource tracker

individuals, by squad.

I have a column for each month.

I want to be able to add up the number of months that have been worked by each individual and then * that by their monthly rate

· Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!