View Single Post
  #4   Report Post  
gls858
 
Posts: n/a
Default

LMB wrote:
Hi Guys,

I have a total in cell C32. I want to subtract numbers in cells C 34-40
and have the answer in cell C41. I know that =C32-C34 will give me an
answer but I want several rows to be subtracted. What would my formula be?

I have used the insert function feature before but I don't see diff or
anything that looks like a subtraction function in there.

Thanks,
Linda

Here's one way..put this in C41

= C32-(SUM( C34:C40))