I have 12 sheets labelled January to December with columns to enter weekly expenditure and a totals column. I want to add each of these totals cells e.g C7 as a sum on page 13 labelled Annual.

The formula I previously used on earlier Excel will not work on the version I have just installed. Help appreciated

As far as I know, there is no such thing as Excel 2012. The latest version for a Windows machine is 2013 and for a Mac it's 2011. It might help if you posted the formula you used in the past and told us what version you used it in.

You should also verify which version you are currently using.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Might you be using Excel 2013? What formula were you using?

All you should need to do is add all the amounts in the C7 (from each sheet) as a formula in the cell on your Annual sheet

Thus, =SUM(Sheet1!C7+Sheet2!C7+Sheet3!C7)

message edited by beachyhbt

beachyhbt, First, using both the SUM function and the addition operator (+) is redundant. If you want to use the addition operator, you don't need the SUM function. If you want to use the SUM function, you should use commas between the arguments instead of the addition operator.

When you use both, Excel is actually doing extra work. Excel will first evaluate the "sum" within the parenthesis by using the addition operators and then evaluate the SUM function based that single result. You can verify this by using the Formula Evaluator and watch as Excel performs the multiple steps. It takes 6 steps to evaluate your formula, but only one step to evaluate a SUM formula with commas.

With that said, there is a much easier way to construct the formula than manually entering each sheet name. For example, this will SUM C7 across all sheets from January to December, inclusive:

=SUM(January:December!C7)

However, I'd still be interested to know the details behind the version issue that MervS is experiencing.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Many thanks for your reply. Yes I do have 2013 - another user has provided a suggestion which worked a treat.

MervS

Many thanks for taking the time to reply. I do use 2013 now and another user provided a suggestion which worked a treat.

MervS

Awesome - the formula worked first time, thank you so much. My error, I do have 2013 on this new PC but as 79 year old I have lost some of my confidence.

Regards

MervS

Ask Your Question

Weekly Poll

Do you think Salesforce should have bought Slack?

Discuss in The Lounge

Poll History