Sum that Sums its cell _ PROBLEM

[jevi]

Hi All,

I got a file and I am very curios as I don't understand it how it is possible or what is the trick.

This file shows in the formula Bar as you can see =SUM(C5:C67) and it is based this formula in the cell C27, but how come it inlcudes also the cell C27 and it gives the result of 53.172,81 in the cell C27 (second immagine).

Weirdly when I hit enter from the formula Bar fx it gives 0,00. Then when I copy the formula and paste it in the next cell ti keeps the same value even though it has other numbers and in the formule bar is corretly showing SUM(H5:H67).

How is his possible? I can't understand it...any idea?

 

[My Aswer Is This]

In your image I see =SOMMA((C5:C67)

Not: SUM(C5:C67)

 

[Fluff]

Having that formula in C2 will cause a circular reference, which is why when you re-calculate the cell you get 0 & whoever created the sheet may have enabled iterative calculations.

 

[jevi]

@MY answer is this : SUM=SOMMA (IN Italian).

@Pluff I did check for interative calculations but was not enabled. I asked them but I have no answer yet.....was not important but I was just curios how they did it.

Thank you,
Jevi

 

[Fluff]

Glad we could help & thanks for the feedback.