View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default SUM to infinity on a column

A correction


=IF(ROW()=1,"Sum",SUM(A1,-B1))


{I recommend SUM(A,-B) here instead simply A-B, to avoid errors whenever one
or both cells are empty or contain text values}


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )