Why is the answer to my formula double what it should be?

H

Hayley B

I am creating a work sheet for my accounts. I have 12 months with different
values. At the end I want to add all the values to make one grand total. I
have added them as follows
(=SUM(B7:E7:B15:E15:B23:E23:B31:E31:B39:E39:B47:E47)
The answer should be 120000-00 yet it says it is 240000-00. Why did this
formula multiply the answer by two??
 
A

aristotle

Assume this is what you're trying to do?

=SUM(B7:E7,B15:E15,B23:E23,B31:E31,B39:E39,B47:E47)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trouble with formula 3
Repeating a formula 3
Countif between Time stamps and have - value 0
14 Day Average REVISITED 4
Macro to run on hidden sheet 4
Why do I get correct answers to formula then #NAME for some no's 1
Macro 2
Macro to tidy data 4

Top