How to get the average number of days within a quarter

Peggy

here is my formula, but I keep getting an error. I can get the average, but now I want to know the average within Quarter 1

=AVG(COLLECT({DYS to Completion}, {Qtr}, "1"))

kira11

If you have a column that says the quarter, I think you could do an average if, something like:

=AVERAGEIF({Qtr}, 1, {DYS to Completion})

Peggy

I left out a criteria, need to know the average days to completion for a specific application within the quarter

=AVERAGEIFS({Qtr}, 1, {Application}, =[Column5]@row, {DYS to Completion})

kira11

Oh got it, I think you could use the COLLECT() then. I think its the quotes around the 1, maybe try:

=AVG(COLLECT({DYS to Completion}, {Qtr}, 1, {Application}, [Column5]@row))