If you gave cell C32 the RangeName "Price", and gave the range C34:C40 the RangeName "Costs", then you could use
=price-SUM(costs)
Vaya con Dios,
Chuck, CABGx3
"LMB" wrote in message ...
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
|