Exel summing problem

Copper Contributor

I have recently been experiencing an intermittent problem with summing using auto sum and with the basic sum+ then +what ever cells I want to sum

Answer I get is 0.00

I have tried reformating, forcing the format, clearing cell contents - but have not found the solution

Whats infuriating is when I copy a correctly aurosummed cell and try to insert it into the problem cell I get the original cell's total

What can I do - any suggestions greatfully received

3 Replies
Hi! Can you pls. send a screenshot with 2 or 3 cells what issue you get? Greets, Eva
Hi Eva
Im a technological Turkey but think this is what you asked for
Cheers
John
image.png

Hi @JJmentions, screenshot isn't here. Try it once again. Greets, Eva.