Average Guest Check ($) When Some Cells are $0.00


I'm trying to get the average of a data set IF the cells are greater than $0.00. Unfortunately, the formulas I've tried have all come up as #UNPARSEABLE. I've included an image of the data for reference as well as the formula I tried based on the syntax suggested. Any suggestions? It might also be worth mentioning that the values in the cells pictured are are populating from an AVG function to summarize numbers from other cells, these aren't manually entered.

=AVERAGEIF([Column2]133:[Column2]144], >0


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!