Using AVG to Calculate Average Completion Time

OFNS BCPS

Good afternoon,

I am trying to find the average of a column and am having problems using AVG, AVG COLLECT, etc.

I am trying to find the average of "Completion Time" column.

As you can see sometimes there is no data and sometimes it says "invalid data" while awaiting the completion date. I want to put an average completion time field in my sheet summary.

Can someone help me? Thanks! @Paul Newcome maybe you can help :)

Michael Culley

If you add an iferror statement to your column formula in Completion Time you can get rid of that error message.

Add this to the front of your formula: =iferror(

Then add this to the back: ,"")

If you copy and paste your formula I can show you better.

Michael Culley

If you add an iferror statement to your column formula in Completion Time you can get rid of that error message.

Add this to the front of your formula: =iferror(

Then add this to the back: ,"")

If you copy and paste your formula I can show you better.

OFNS BCPS

Thank you so much, that solved my problem!