Excel total

  ArrGee 11:17 11 Nov 2006
Locked

A bit of adding up help needed please.

If I have a column of, say, ten numbers (currency) and wish to make the last cell the total, that is no problem. All of the cells are formatted as currency.

But if one of the numbers has text placed into the cell instead, the total does not work.

How can I get around this?

Thanks in advance.

  VoG II 11:20 11 Nov 2006

How are you calculating the total?

=SUM(A1:A10)

should give the correct answer (ignoring any non-numeric entries in the range).

  ArrGee 11:23 11 Nov 2006

Thanks, problem sorted!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?