Solved

Autosum doesn't add

Posted on 2014-04-14
1
200 Views
Last Modified: 2014-04-14
I attached an excel sheet.

If I do and autosum of  =SUM(G3:H3) in cell J3, it works fine.  However, when I use the fill command for J3:J10, it outputs the same data in all the boxes.  

Why is it doing that?

Please try and see.
Sample.xlsx
0
Comment
Question by:al4629740
1 Comment
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39999240
I would guess that you have automatic calculation turned off as it works as expected here. Does the status bar say 'calculate' by any chance?

Press f9 to force a calculation or go to Options, Formula and set calculation to automatic
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now