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

Hannah Hall

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

Jeff Reisman

@Hannah Hall

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)

😀

Jeff Reisman

@Hannah Hall

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)

😀

Hannah Hall

Thank you, Jeff!!