Hi everyone
I wonder if you could please help me with the correct syntax for a SUMIFS formula? I've tried everything (although clearly not!) to get this to work, but I'm having no luck.
Here's what I'm trying to achieve:
SUM the total of column L if the contents of column M on a tab called _oneoff is London and the contents of F on the same tab is Annual
Here's my current formula which gives me the error "The syntax of this name isn't correct":
=SUMIFS(_oneoff!L:L,_oneoff!M:M,"London",[_oneoff!F:F,"Annual"])
Many thanks,
Jon
Bookmarks