Thread: Excell formula.
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Excell formula.

IF? you want to sum c12:c13 and then subtract the sum of d14:d17

=sum(C12:C13)-sum(D14:D17)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"azarat" wrote in message
...
I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the
result
in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS
would
work.
Help Help Help;.