SUMPRODUCT last Column

If anyone know any other way please say. I can upload the spreadsheet if helps understanding better.

can you use a named range for the last column ?

I have defined the last column as "AIlc" and used it as instead of AI!$AY$2:$AY$366 but the return is VALUE or NAME.

Originally Posted by wayneg

can you use a named range for the last column ?

I have defined the last column as "AIlc" and used it as instead of AI!$AY$2:$AY$366 but the return is VALUE or NAME.

Originally Posted by wayneg

can you use a named range for the last column ?

Thanks Yasser,

It does look very sensible. I was thinking the same idea but didn't know how to interprete it into vba. I am getting "Application-defined or object-defined error" message on below line. Any idea how can I fix that?

Please Login or Register  to view this content.

Thanks,

Originally Posted by YasserKhalil

Hello Hanif
Try something like that (Not Tested)

Please Login or Register  to view this content.

Sure you didn't get the lower case "L" mixed up with the number 1?

Please Login or Register  to view this content.

They look alike when written.

Yes, I have double checked but still getting same error message!

Originally Posted by JOHN H. DAVIS

Sure you didn't get the lower case "L" mixed up with the number 1?

Please Login or Register  to view this content.

They look alike when written.

Yes, I have double checked but still getting same error message!

Originally Posted by JOHN H. DAVIS

Sure you didn't get the lower case "L" mixed up with the number 1?

Please Login or Register  to view this content.

They look alike when written.

Please do not quote when you reply! Just reply will do.
I have tested it and it works.
Also use Option Explicit with the code to spot out a typo

Please Login or Register  to view this content.

That's the only thing I see that would produce that error. What about in your Dim statement?

I have checked them all, they are all fine. AIlc gives me a value of 166248. Would this could cause the problem?

Originally Posted by JOHN H. DAVIS

That's the only thing I see that would produce that error. What about in your Dim statement?