Hope you're keeping well.
I've recently started playing with IFERROR's and updating some existing sheets.
I have a sheet that reports with each row being a week of the year. Many of the formulas for "Rows in the future" or in some case, "Rows in the Past" return DIV0 or similar errors which I'm trying to eliminate.
Im struggling with the below formula - any recomendations / advice as to where an IFERROR should be inserted?
This formula is in the red squared cell.
For interest, the formula is used to calulate an adjusted 'rolling' sales target for a salesperson, by deducting Sales in so far for the month from their original month sales target, and dividing by the number of weeks remaining in the month.
=([Total Sales Target]35 - [Total Sales]35) / COUNTIF([Week number start date]36:[Week number start date]40, >TODAY(-7))
Any advice appreciated!
Help Article Resources
Check out the Formula Handbook template!