=A1-SUM(A2:G2)

???

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Richard" wrote in message
...
I don't want to subtract just G2 from A2. I'd like to subtract A2 thru G2
(A2:G2)

"bigwheel" wrote:

"Richard" wrote:

How do you subtract, example: A2:G2

To subtract A2 from G2 enter the formula =G2-A2 into a cell