How do I subtract line k from line L in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
=L-K


=sum(L:L)-sum(K:K)

if that is what you mean, your question is a bit cryptic

Regards,

Peo Sjoblom
 
Heidi

L and K are columns, not "lines".

To subtract K1 from L1 enter in M1 =L1-K1

To subtract a range in one formula.......

=L1:L100-K1:K100 entered in M1


Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Keeping excel from performing subtraction so text remains as is 2
Word want multiple lines in Word Footer - with different formats 1
how do I keep excel from calculating text so it stands as is? 4
subtraction 2
Formula Help 9
Starting a new line 2

Back
Top