View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
C. Trom.[_2_] C. Trom.[_2_] is offline
external usenet poster
 
Posts: 1
Default excel subtraction issues

Sean,
Thanks, just what I was looking for. I do appreciate.

"Sean Timmons" wrote:

Depending on if the cells are all in a row, let's say the cell to subtract
from is A1 cells are A2 - A33, then you type =A1-sum(A2:A33). If not
consecutive, type =A1-(each cell to subtract from it)

"C. Trom." wrote:

Need to subtract from over 32 columns but get (too may argumnets) error
message,

is there work around ?