SUMIFS help

[trevormay99]

I am trying to sum total work hours by week according to the current date, on multiple sheets. But my first line of code throws an error despite working as a formula on the spreadsheet itself.
Next week, week 3 and week 4 work perfectly fine but when I try to sum for the current week the macro wont run. Any tips?

 

[Michael M]

Can you post the entire code and not a picture please. I think you are missing ectra inverted commas at the

""""<""""

 

[Peter_SSs]

Welcome to the MrExcel board!

despite working as a formula on the spreadsheet itself.

I don't think that is so since it has mis-matched opening and closing parentheses. It has 12 "(" but only 11 ")"
I think that you need 5 ")" at the end and you only have 4.
I believe that your inverted comma are correct.

 

[trevormay99]

Welcome to the MrExcel board!


I don't think that is so since it has mis-matched opening and closing parentheses. It has 12 "(" but only 11 ")"
I think that you need 5 ")" at the end and you only have 4.
I believe that your inverted comma are correct.

That did it thank you! good eye

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

Next time though, please paste the actual code not an image and use the available code tags. It makes your code much easier to read/debug & copy. My signature block below has more details.