How do you subtract, example: A2:G2

"Richard" wrote:

How do you subtract, example: A2:G2

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

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

How about this:

=-SUM(A2:G2)
--
Regards,
Ron

=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

Subtracting C2 thru G2
Example: If C2 had 3436, D2 had 3395, E2 had 3376, Then answer in F2 would
be 60
Still can't figure this one out! Thanks so much in advance for any help!!

"Ron Coderre" wrote:

How about this:

=-SUM(A2:G2)
--
Regards,
Ron

On Sat, 21 May 2005 17:28:01 -0700, "Richard"
wrote:

Subtracting C2 thru G2
Example: If C2 had 3436, D2 had 3395, E2 had 3376, Then answer in F2 would
be 60
Still can't figure this one out! Thanks so much in advance for any help!!

"Ron Coderre" wrote:

How about this:

=-SUM(A2:G2)
--
Regards,
Ron


=MAX(C2,D2)-E2

But I think you are not giving us enough information to be able to give you a
proper answer.


--ron