Calculate the right average for the columns
I need the average collect to calculate the right total % complete for the columns
Each column that has a date is = 100%
If there is no date is = 0% but the formula still counts the 0% to give the total % average complete on "Quote % Complete" column.
If there is "N/A" either in "1st Circuit Quote Status or 2nd Circuit Quote Status" column, the formula will skip the columns for either "1st or 2nd Circuit Quote" (the 3 columns on the left side of Circuit Quote Status) and calculate only the columns that don't have the Circuit Quote Status "N/A".
I hope someone can help me!
Thank you very much!
Help Article Resources
Check out the Formula Handbook template!