unable to get the sumif property of the worksheet function class -> HELP!!!

hi guys, i have the following code:

Please Login or Register  to view this content.

once i run the macro, i get an error saying: Unable to get the sumif property of the worksheet function class and i have no idea why or how to get around it. please help!!

Remove the brackets [] from the third argument in the SumIf

Please Login or Register  to view this content.

Absolutely genius :D :D thank you