Excel Formulae

  • Thread starter Thread starter KenS.
  • Start date Start date
K

KenS.

I've been trying hard to find a formula which would
enable me (from one cell) to Add several cells and
Subtract the answer from another cell (subtracting items
of expenditure from a starting total). I could manage
this with Lotus - but Excel does not seem to behave the
same. Advice would be much appreciated. Thanks,
Ken.
 
One way:

Say you wanted to subtract A1, A2, A3, J4 and N5 from L6:

=L6-SUM(A1:A3,J4,N5)
 
Back
Top