View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

Subtracts from what?

If you're subtracting all the other cells from C2, perhaps something
like:

J9: =SUM(C2,-D3,-E4,-F5,-G6,-H7,-I8)


or, more compactly:

J9: =-SUM(-C2,D3,E4,F5,G6,H7,I8)




In article ,
wrote:

How would you write a formula that subtracts qty in cell
c2,d3,e4,f5,g6,h7,I8 total rusults in J9