Excel help needed

  boygeorge 17:34 20 Aug 2008
Locked

Does anyone know a formula for subtracting several cells, without entering a "minus sign" before each cell that you want to include.
If adding, you can insert, say C3:C24 and those cells and the ones in between are added together. However, I can't find how to make the same kind of shortcut for subtractions.
Thanks in advance

  VoG II 19:26 20 Aug 2008

Try

=C3-SUM(C4:C24)

  boygeorge 20:41 20 Aug 2008

Thanks VoG, saved what bit of hair I've got left.

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

Elsewhere on IDG sites

Honor 9 Lite review

How Social Media has Propelled Political Graphic Design and Art in the Last Decade

The best kids apps for iPhone & iPad 2018

HomePod d’Apple : date de sortie, prix et fiche technique