New numbers not included in totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know what is happening - but I have several columns with sum(A2:A13,
B2...)in row 14. When I enter data for the next month within A, Row 14 does
not change. If I enter =sum(a2:a13) in another cell (row 16, for instance),
it totals all the cells. But - if I enter numbers in another cell in row A,
neither row 14 or 16 reflects the additional data to summarize.

The only thing I've done is added Chip Pearson's Rowliner.

TIA,

Carole O
 
Hi
try: Tools - Options - Calculate and enable automatic calculation
 
You are wonderful!! Thank you. Now all I have to do is figure out which
gremlin changed the setting!!

Carole O
 
Hi
this is an application level setting. The first opened workbook
determines the setting for the other ones. So maybe you opened such a
workbook
 
You must log in or register to reply here.

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

sumif for a specific number of cells 2
Lookup and Calculate Formula 10
How to update/change cell references in a formula 2
getting info from array but not using column / row numbers 4
How to use indirect function? 6
Data Entry - Write to next cell 3
Excel How to find the most common pairs and triplets numbers? 5
Duplicating Cell to another cell if it contains data 4

Back
Top