Sumproduct with Named Range

Hi all,

Been trying to resolve a "hard-coded" range by using Named Range but has been returning "#VALUE!"

By using the below formula; where range J14 to J2608 is hard-coded, it will work.

Please Login or Register  to view this content.

But by changing range J14 to J2608 into a Named Range (see below); the whole thing fails.

Please Login or Register  to view this content.

Please help!

Cheers,
CL

the Value error means that the ranges are not the same size. Check the definition of PlanRev.

See here for a discussion of Sumproduct error messages http://spreadsheet-toolbox.com/libra...error-message/