# Thread: Problem with formula (2003)

1. ## Problem with formula (2003)

I am having problems with the formula below. It works up until it trys to look up '10' onwards and then it goes wrong. i am at a loss!!
=IF(ISERROR(AVERAGE(IF((Data!\$E\$2:\$E\$5001=\$Q65)*(L EFT(Data!\$G\$2:\$G\$5001,3)=LEFT(S\$64)),((Data!\$I\$2:\$ I\$5001))))),"-",(AVERAGE(IF((Data!\$E\$2:\$E\$5001=\$Q65)*(LEFT(Data! \$G\$2:\$G\$5001,3)=LEFT(S\$64)),((Data!\$I\$2:\$I\$5001))) )))

I would appreciate any help!!

2. ## Re: Problem with formula (2003)

Welcome to Woody's Lounge!

I'm confused by your question - the workbook that you attached doesn't contain any formulas, and the formula in your post refers to cells Q65 and S64 that are blank in the sheet.

But I suspect that your problem is caused by LEFT(S\$64). You should replace both instances in the formula with LEFT(S\$64,3)

3. ## Re: Problem with formula (2003)

That worked a treat Hans thank you. that was what the problem was.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•