Hi Dave,
I have created 4 different range names of 5000 cells each.
But still I am getting the same error.
Any thoughts?

Regards,
Madiya


On Aug 22, 6:47 pm, Dave Peterson wrote:
Can you reduce the range--not use 20000 rows?

If not, maybe you can use multiple formulas and multiple ranges (5000 rows
each?).





Madiya wrote:

I have created several external named range, for e.g.
='C:\Documents and Settings\madiya\Desktop\[RUIM Master
File.xls]Reciept Data'!$E$1:$E$20000

I intend to use it in sumproduct formulas but on testing I got error
as below.

Excel cannot complete this task with available resources. Choose less
data or close other applications. <OK button

I used the same in counta formula. While saving the file above error
came up.

Need help to resolve the issue.

Regards,
Madiya

--

Dave Peterson- Hide quoted text -

- Show quoted text -