Excel subtraction question
 

I have a number in a cell A3 and about 40 numbers in 40 other cells that I
want to subtract from the number in A3. I tried = A3-C1:C39 but that did not
work.

What is the easiest and correct way to perform this calculation?

Thanks

Excel subtraction question
 

Try this:

= A3-SUM(C1:C39)

Hope this helps.

Pete

On Dec 11, 12:55 pm, Dig wrote:
I have a number in a cell A3 and about 40 numbers in 40 other cells that I
want to subtract from the number in A3. I tried = A3-C1:C39 but that did not
work.

What is the easiest and correct way to perform this calculation?

Thanks

Excel subtraction question
 

=A3-SUM(C1:C39)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dig" wrote in message ...
|I have a number in a cell A3 and about 40 numbers in 40 other cells that I
| want to subtract from the number in A3. I tried = A3-C1:C39 but that did not
| work.
|
| What is the easiest and correct way to perform this calculation?
|
| Thanks

Excel subtraction question
 

Try =A3-SUM(C1-C39)

Les



"Dig" wrote:

I have a number in a cell A3 and about 40 numbers in 40 other cells that I
want to subtract from the number in A3. I tried = A3-C1:C39 but that did not
work.

What is the easiest and correct way to perform this calculation?

Thanks

Excel subtraction question
 

Ooops. Fingers slipped. Corrected formula: =A3-SUM(C1:C39) Use colon,
not minus sign for range.

Les

"Dig" wrote:

I have a number in a cell A3 and about 40 numbers in 40 other cells that I
want to subtract from the number in A3. I tried = A3-C1:C39 but that did not
work.

What is the easiest and correct way to perform this calculation?

Thanks