Help with formula conversion of XLSX to 2003 format Excel

**asanthadenz** · 07-18-2013, 11:33 PM

Hey guys,

Im new to the forum so hello

I need some help with the following XLSX file, you see this was edited using 2007-2010 version of Excel and when i convert this to be opened in 2003 version of Excel all the Formulas in the LEAGUE TABLE tab including the hidden sheets goes in Error.

I need someones help to:
1. Convert this to 2003 format so its viewable to 2003 Excel
2. Make sure the formulas all work in Excel 2003

Thank you all for you help

San

**jhren** · 07-19-2013, 12:07 AM

AFAICT, all the errors originate on the Calculations tab, columns D, H, I, and O, because of the COUNTIFS and SUMIFS not being compatible. Search web for "converting <insert function name here> to Excel 2003".

**benishiryo** · 07-19-2013, 12:10 AM

hi San, 1 eg of what jhren mentioned; in D3 of Calculations sheet:

Formula:

Please Login or Register  to view this content.

you seem to know how to use SUMPRODUCT, so i assume you'll have no problems. there are too many formulas to change. let us know if you face a problem in any, rather than us providing you all of it. also, with SUMPRODUCT, try not to range the whole column. notice your file takes awhile to calculate.