Excel Question ... I'm going mad

WLM21

I've recently started playing the game Yahtzee with the kids and for a bit of a laugh as well as to make life easier I set up a spreadsheet to calculate the scores.

Below is a copy

For some reason in cell C19, my initial sum is changing all by itself as I type in figures above ... What's more, I get to the lower section, the whole cell flashes. It started out as a sum of C5 to C10 and without going near it, it is now showing as C5 to C17

What's going on please ?

WLM21

I've just entered 2 in the top 6 rows of each column ... the correct totals are showing (12) in the first sum cell.

Then adding 3 in all the lower cells, the sum calculation is being changed by something, to give a new total in each row of 33, rather than it being left as 12. The lower section scores are OK, showing as 21

ABOUT TO GO TO THE TYNE BRIDGE .. TO JUMP OFF ... MAYBE !!!

ValHaller

It could be to do with the way you went about wring the spreadsheet. If you did the upper section score first and then added extra rows, it could have automatically extended the range of the total from (c5:c10) to (c5:c17) as you added the rows and it could be flashing to indicate that the range has not been manually checked.

Not that I have used a spreadsheet for years.

bubblesbonbon

ValHaller is right. If you insert cells after creating a range formula, Excel will extend the range accordingly.
Just re-enter the correct formulae

WLM21

bubblesbonbon wrote: »

ValHaller is right. If you insert cells after creating a range formula, Excel will extend the range accordingly.
Just re-enter the correct formulae

Thanks !

I have actually entered the right formula several times, then saved the spreadsheet again ...

But it still changes

I think I'll just delete off all, the bottom, then enter it again from scratch, or maybe change the SUM function to an A + B + C + D + E + F style formula. Surely the computer won't think "What about G and H etc etc"

If it does ..then computers are more clever than we thought. And here's me thinking about that expression GIGO.

Frogletina

If you look at the boxes where the formulas are you will see some have little green triangles in the corners.

I'm not an expert with excel but if you click in the box you will get a little box with an explanation mark. This indicates an error/possible error with the formula and if you click it you will get further information.

WTFH

Ok, a few comments...
1. Your "if" statement for the bonus calculation is not the best. Rather than it being 35 or blank, it should be 35 or 0
2. Don't use "sum" to add 2 numbers together, just add them!

So, how are you copying the formulas in column C into D?
Excel will not mysteriously change formulas.

WLM21

Frogletina wrote: »

If you look at the boxes where the formulas are you will see some have little green triangles in the corners.

I'm not an expert with excel but if you click in the box you will get a little box with an explanation mark. This indicates an error/possible error with the formula and if you click it you will get further information.

I never knew about those triangles before. On the current spreadsheet, it was not showing, but when I started entering data and cells flashed .. up the triangle popped.

Anyway, I've got it all sorted now (not a SUM function in sight now)

Thank you for all the replies

HAPPY CHRISTMAS TO ALL