Solved How do I write a formula in Excel 2012 as detailed below

May 20, 2015 at 21:48:59
Specs: Windows 8.1
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

See More: How do I write a formula in Excel 2012 as detailed below

Report •

#1
May 21, 2015 at 04:11:56
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.


Report •

#2
May 21, 2015 at 04:12:12
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


Report •

#3
May 21, 2015 at 04:50:54
✔ Best Answer
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


Report •

Related Solutions

#4
May 21, 2015 at 20:08:45
Many thanks for your reply. Yes I do have 2013 - another user has provided a suggestion which worked a treat.
MervS

Report •

#5
May 21, 2015 at 20:11:23
Many thanks for taking the time to reply. I do use 2013 now and another user provided a suggestion which worked a treat.
MervS

Report •

#6
May 21, 2015 at 20:15:13
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

Report •

Ask Question