Dear All,
I've created a spreadsheet with numerous SUMIFS formulas (1,475 to be exact)
When I rolled it out to the rest of the company it was soon discovered that they had Excel 2003 not Excel 2007 like myself. Consequently it doesn't work.
My desire to change 1,475 cells to a sumproduct...