Reference cells in another sheet WITHOUT having to use named ranges
can anyone tell me how to use the following formula on a *different* sheet than the columns referred to in the formula...
=SUMIF(MonthYear:MonthYear, FIND("19", @cell) > 0, [AW1]:[AW1])
(This formula works great when it's in the same sheet (A) as the one with columns name MonthYear and AW1, but I can't figure out how to make it work when I put it in another sheet (B).
I have tried putting the name of sheet A in curly braces... but not found a syntax that works?!
In Excel this would be easy... but SmartSheet has got me dumbfounded!
Thanks in advance,
P.S. I don't want to use named ranges to refer to sheet A ... because the next thing I want to do is make the name of the column shown as 'AW1' a relative reference so I can do HLOOKUP.
Help Article Resources
Check out the Formula Handbook template!