A name can contain up to 255 characters If a name that is defined for a range contains more than 253 characters, you cannot select it from the Name box, but you can still use it in formulas Case sensitivity Names can contain uppercase and lowercase letters, but Excel Using Worksheet Name in Sumif Formula Sheet 1 has a header row in row 1 In Column A from row 2 thru say 10, will have the individual tab names that are in the workbook In Column B is where the sumif formula will be Example Sheet 1 Col A Col B Col C Col D Col E It usually is the fastest way Contents hide Method 1 Insert the sheet name using builtin Excel functions Method 2 Return the sheet name using VBA Method 3 Use 'Professor Excel Tools' Example Take it a step further Insert and clean a worksheet name Download example sheet and further reading
Excel Indirect Function Basic Uses And Formula Examples