lol im here, I was awake late and been asleep all morning! right, my spreadsheet is showing week by week % sales by year/region/soc (shape of chain), so I have these 3 headings under every week. at the end I want to run a running progressive, but as the formula contains blank cells (as there is...