Excel SUMPRODUCT Error Question

  • Thread starter Thread starter jludka
  • Start date Start date
J

jludka

I have used the sumproduct function on a small sample of my worksheet t
test it and it works perfectly. This allowed me to test the inpu
ranges such as a2:a30 and c2:c30 and e2:e30.

On my larger worksheet, when I write the same equation, I continuousl
get the #VALUE! error. The only difference in equations is that m
ranges are now a:a and c:c and e:e. I have tried a few things tryin
to work out the "bug", but to no avail.

Any suggestions on what could be causing this error?

Thank you, Jaim
 
Jaime,

SUMPRODUCT won't work on a full columned, you need to specify the range,
such as A1:A1000 or even A1:A65536

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
such as A1:A1000 or even A1:A65536

A1:A65535 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Bob Phillips said:
Jaime,

SUMPRODUCT won't work on a full columned, you need to specify the range,
such as A1:A1000 or even A1:A65536

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
You can't use the whole column like in c:c
use c1:c65535 or something. Do you really plan to fill over 65000 rows?
Use something less maybe c1:c10000
 
Ooops! I wasn't supposed to give away details of MS' next release!

Bob

Ken Wright said:
such as A1:A1000 or even A1:A65536
Click to expand...

A1:A65535 :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------------------------- --
Click to expand...
 
Wow - Seeing into the future is one thing, but that far ahead is amazing!!!!
(Won't hold my breath waiting for that change methinks) :-)
 
Gee, Ken, didn't know you'd been involved in the beta...

MS's next XL release is Excel 2004 for Mac, announced this past
Tuesday, and due "this Spring"...
 
Back
Top