How to write Sum - Sumrange formula

[igmike]

My data Occupies Cells J-P, I would like to simply the formula in P by using sum range to subtract K-O, from J. I can't recall how to do so. Any help is appreciated.

J=Sold Price
K-O= Fees
P= J-K-0

Data:
K= J*.1
L=COG
M==SUM(J3*0.03)+0.3
N=varied number
0=J*.06

 

[pjmorris]

in P: =J1-sum(k1:O1) perhaps?

 

[igmike]

Thanks!