Sum function changes arguments

  • Thread starter Thread starter Dianeg
  • Start date Start date
D

Dianeg

A client's spreadsheet shows a sum function which calculates individual cells
for instance =sum(B2,B4,B6,B8) then saves and closes the workbook. When she
reopens it, the sum reads =sum(B2:B8). She couldn't duplicate the error
whilst I was there but is adamant that nobody edits the workbook. The
calculation mode is automatic and version 2007

Is this really possible???
Regards

Diane
 
Doesn't sound like it, and if she couldn't reproduce it, then it seems even
less likely (how many times have I said that and been wrong :-().


HTH

Bob
 

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

sigma function 1
Define variable range input for SUM() function 8
formula to sum all sum calculations in a column 4
Sumproduct + Array Function? 4
Sum formula not working 1
Using SUM function with #N/A in some cells 5
The sum of data based on words 3
Auto Sum Function 3

Back
Top