Hello. I'm hoping someone can help me figure out how to properly write this formula so that it will exclude zeros in the average. The average is coming in lower than it should based on when I manually filter in the column for the same time period in the raw data. Here is the formula that I'm currently using:

=AVERAGEIFS(Table1[Est Proj Revenue],Table1[Aggregated Status],"Lost",Table1[dtSubmitMo],VP_Mo,Table1[dtSubmitYr],VP_Yr)


I am trying to average the estimated project revenue column [Est Proj Revenue] where the status column [Aggregated Status] indicates "Lost" for deals submitted during a particular month and year 'Table1[dtSubmitMo],VP_Mo,Table1[dtSubmitYr],VP_Yr'

The formula is working (I've gone through several variations of the same formula and this seems close.) However, I am at a loss as to where to include the "<>" in the syntax to tell the formula to "not count zeros" in the [Est Proj Revenue] column.

There must be something in here that can help me get the average I need for these particular records. Any ideas?