i have a google sheet with 200+ tabs, in every tab there is a sum number in different cell locations.
on every tab there a cell named “total” next to the sum number one column beofore.
if the sum number is in column E the “total” cell is in D.
i need a formula that finds all the numbers in the different locations and display/sum them

I am trying to work with a data set and the first and last names are in separate columns and they need to be in just one

So I have this cell function I found for an Excel workbook

I am trying to make a table consisting of X values, f(x) values, and g(x) values. Here is a desmos graph of the two functions: https://www.desmos.com/calculator/vint4ossia. (They are in blue). while I did get f(x) down into google sheets, g(x) is giving me errors.