Complex Formula, Error 504-Can't find where I went wrong

[Dexter1759]

If you don't require a monthly breakdown and just a total perhaps the following would do you....

=(MIN(BaseQuota,SUM(YTDSales))*2)+(MAX(SUM(YTDSales)-BaseQuota,0)*4) 

Where YTDSales is a range representing Jan to Aug sales.

I like avoiding IFs where I can because it can end up being confusing when you come back to read/edit it at a later date, and tends to lead to near duplication between the TRUE and FALSE parts, which can also be a pain for future changes.

Of course, it's a slightly different matter if you require a monthly breakdown. In which case I suggest an "Points Balance" column into the data that shows a per month points and then sum that column for the total.