Excel help needed

  boygeorge 17:34 20 Aug 08
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 08

Try

=C3-SUM(C4:C24)

  boygeorge 20:41 20 Aug 08

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

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…