Add punctuation: For example you can have the name ThisMonth represent the range A1A10 on many different Worksheets Then if you used SUMThisMonth the SUM would always sum A1A10 of the sheet the formula resides on


For example, you can have the name ThisMonth represent the range A1:A10 on many different Worksheets. Then, if you used =SUM(ThisMonth) the SUM would always sum A1:A10 of the sheet the formula resides on.