Imagine that your supervisor in the fictitious WYZ Widget Company needs you to calculate how much of the assigned budget was actually used you can find the file here. Enter a formula that contains a built-in function Select an empty cell. Convert this range to the table by pressing Ctrl T.
Use the AutoSum button to calculate basic formulas such as SUM AVERAGE COUNT etc.
Now we have a total of the table row at the end of the table. FIND returns 1 when find_text is empty. FIND will return VALUE if find_text is not found in within_text. The index number represents the numeric sequence of sheets in an Excel workbook starting with 1 on the left and ending with N on the left where N is the total number of sheets in the workbook.