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

OnePlus 5 review

50 best online Adobe XD tutorials

iPad Pro 10.5in (2017) review

Comment connecter un MacBook à une TV ?