View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default 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