Excel issue - autosum

Occasional Visitor

Hi,

 

I faced this issue first time. My cells are in number format. I try to use autosum function but

excel gives =SUM(#REF!) error.

PasiN2170_0-1660541219497.png

But when I manually enter formula for same area, it works. 

PasiN2170_1-1660541275003.png

PasiN2170_2-1660541287426.png

I do not figure out the root problem with autosum function.

1 Reply

@PasiN2170 

Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.