We help IT Professionals succeed at work.

Excel Formular

rperault
rperault asked
on
269 Views
Last Modified: 2012-05-11
Experts,

I am trying to come up with a formular for Excel. It is very very easy but I CAN'T Get it to work for some reason.


= SUM (D2+D3+D4+D5)*12

So what I would like to do is add the total of those 4 cells and multiple that by 12, and give the output. into D7
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
or

=sum(d2,d3,d4,d5)*12

or

=sum(d2:d5)*12

Author

Commented:
Perfect Thanks
Saqib HusainEngineer
CERTIFIED EXPERT

Commented:
your formula should work equally well if

- there is no space after the sum and before the bracket

- there is no non-numeric value in any of the 4 cells
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.