Formula 2003

**thingssocomplex** · 06-13-2011, 03:06 AM

I am currently using Excel 2010 , I prepared and saved a spread sheet in compatibly mode. A user with Excel 2003 gets an error for the below forumula does anybody know why?

=IF(E13=0,0,(E11*H9)+SUM(I19:I34)+H13)-H15

**TMS** · 06-13-2011, 03:15 AM

I suspect E11, H9,H13, or H15 has a non numeric value.

Regards

**Roger Govier** · 06-13-2011, 03:17 AM

Hi

Nothing to do with the XL version.
There must be something wrong with the data in those cells.
What error do they get?
Are there any text values or text numbers where you are expecting numeric values?

**thingssocomplex** · 06-13-2011, 03:55 AM

I was using SUMIFS which are not available in 2003 I had to change cells to Array Formulas I am guessing this is the causing the issue when I try to calculate on the results of each Array Formula in a cell.... Is it possible to correct?

**TMS** · 06-13-2011, 04:14 AM

It would help us to address your problem if you told the full story from the outset. Clearly, this is not simply a case of a "simple" formula works in one version of Excel and not another, earlier version.

Please post a sample workbook with the actual formulae and some typical data. It would make sense, under the circumstances, to post the 2010 workbook and the modified 2003 workbook.

Regards

**thingssocomplex** · 06-13-2011, 04:28 AM

I will put some dummy data in the spread sheet and attach a copy. I don't have a version in Excel 2003, simple because I don't have 2003 and have never used Excel 2003, this is what is causing the issues I cannot see what the end user is seeing, everything works fine on my version....

**TMS** · 06-13-2011, 04:37 AM

Before SUMIFS was introduced in Excel 2007, I would have used SUMPRODUCT.

If you post the SUMIFS formula, it should be simple enough to convert it to SUMPRODUCT.

Equally, if you post the sample workbook in 2010, I should be able to amend that as an example.

Regards