'438' - object doesn't support this property or method error, in the "Sumif" Function line

I dont know why it gives me '438' - object doesn't support this property or method error, in the "Sumif" Function line.

How can I do the sumif function in VBA?

Please Login or Register  to view this content.

And here's the whole code:

Please Login or Register  to view this content.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.