Average Guest Check ($) When Some Cells are $0.00
Hello!
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

You were soooo close! You just need an end parentheses after the zero to close out the AVERAGEIF function, and get rid of the bracket after 144.
=AVERAGEIF([Column2]133:[Column2]144, > 0)
😀
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers

You were soooo close! You just need an end parentheses after the zero to close out the AVERAGEIF function, and get rid of the bracket after 144.
=AVERAGEIF([Column2]133:[Column2]144, > 0)
😀
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Thank you, Jeff!!
Help Article Resources
Categories
Check out the Formula Handbook template!