Formula in metrics sheet to average numbers in column in source sheet
I have a source sheet containing two date columns and a helper column containing a formula to calculate the network days between the date columns. (Example of several rows of my 600+ row source sheet.)
In my metrics sheet, I want to calculate the average of the Days to Complete Termination column in my source sheet and I don't want the rows with 0 to be included in the average calculation.
I've looked in the Community and found similar questions. I've tried =AVERAGEIF([OFF-DaysToCompleteTerm]:[OFF-DaysToCompleteTerm], <>0, [OFF-DaysToCompleteTerm]:[OFF-DaysToCompleteTerm]) and it returns #UNPARSEABLE.
Thanks for any help on this.