Excel 2007 : Need code for subtracting values in different coloumns

[bodmas]

Hello Everyone,
Please guide me for subtracting values in different coloumns.
I want to subtract all the values in "L" column from "F" column.
Suppose in cell [F21 = 1000, F22= 2000] and cell[L21=200,L=400,L=200]. I want to SUM both columns in N7. Please give me the code for the above.
Advance thanks

[pike]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[bodmas]

[SOLVED]

=SUM(F1:F99)-SUM(L1:L99)

@Pike ~ Thanks for your suggestions.