I want to create a spreadsheet where column A has a list of numbers and column B has the totals.

Say cell A1 has the formula A2 + A3

and B1 has the formula B2 + B2

and C1 has the formula A1 + B1

I need an easy and quick way to create the formula for C1 in the flattened state..

i.e.
(A2 + A3) + (B1 + B2)

Although the above example is trivial, I am trying to simplify a formula that refers to around 40 cells (and around 70 calls through a third party plugin).

Any help appreciated!

Hi All;

I try to create a excel like table with headers and some fields containing values, other long and complex mathematic formulas.

HELP!. I have an Excel Workbook with multiple sheets. I am trying to create a consolidated sales report pulling data from each individual monthly sales spreadsheet. Some of the items have more than one price based on quantity. For example, Item A is $30 for 1-11 and $28 for 12+. Problem is they have the same item number.

I want to create a spreadsheet where column A has a list of numbers and column B has the totals.

I have a formula that shows hours and minutes of how long it took to notify a client.

I am trying to create a formula that considers the data from three columns Y, H and V on my tab titled 'Data', returning the smallest value in A that meets that condition, once found Vlookup that smallest value and return the value from B. Below is what I have so far, and it is working until I try to add in my last condition.

I'm trying to create some named ranges in Excel that extend using the offset function based on the number of non-empty cells in a column, with the general formula:

=OFFSET($E1,0,0,COUNTA($E1:$E99999),1)

The name manager accepts the formula, but when I go back into it it seems to have changed some of the numbers randomly. The named ranges do not function as excepted.

I have an excel spreadsheet containing a list of names and "scores" that they have received for a specific date. Each name should have 3 scores each month and I'm looking for a formula that can help keep track of this. So for example, if John Smith has been entered 3 times in the file there will be a 1,2, or a 3 next to the instance so that I know he's reached his final score for the month.