excel formula changing????? help

S

Suzanne

I am having a problem with my formula changing all of the
sudden. For example, I have columns A1 through A20
A21 is adding columns A1 thru A7 =SUM(A1:A7)
A22 is addding columns A8 thru A10 and A14 thru A20
=SUM(A8:A10,A14:A20)
A23 os adding columns A11 thru thru A13 =SUM(A11:A13)

The problem is that cell A21 is all of the sudden adding
cells A1 thru A20, I have changed it back a million times
and cannot figure out why it keeps reverting back to add
the whole row. I have used this formula for the past year
and now I am having this problem. What could I be doing
wrong.
 

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

how to use an formula to transpose a list(left) to be like the right? 2
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Bug in Excel? 2
sum if 1
How to appy the formular with different cell parameters~kindly hel 2
Remove specific cells in a column. 2
help with datedif function please 5
IF Statement problem 0

Top