View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
fantomet fantomet is offline
external usenet poster
 
Posts: 3
Default Autofill counting up Columns and Rows!

Hi Having some trouble with autofilling a formula that looks like this:
=SUM(A9550:A10806) and i want it to autofill down like this by draging the
handle down:

=SUM(A9550:A10806)
=SUM(B9551:B10807)
=SUM(C9552:C10808)

that is both column AND row value should increase!

-- ------------------ ------------
Power Student With Power in My Power Boots