How best to AVG a column of numbers created by formulas, and some cells have #INVALID DATA TYPE

slando ✭✭
edited 06/20/22 in Formulas and Functions


I have setup a sheet where I have 2 date columns that represent when I open a Support Ticket (Date Discovered & Date Resolved). I added a third column to show me the NETWORKDAY Formula so it will show me the number of "workdays" between those two columns. Works fine!

Now I have a GRAND TOTAL ROW that I'm trying to capture the totals of some columns, one of them is that I am trying to get the AVERAGE of an entire column called "Average AP Support Cases in days", but in some cells it has the #INVALID DATA TYPE which in turn, is preventing me from calculating an overall AVG of the entire column.

Any suggestions?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!