| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cutting and pasting from rows into columns and visa versa. | New Users to Excel | |||
| Counting rows based on multiple columns | Excel Worksheet Functions | |||
| autofill information from rows to columns without using transpose | Excel Discussion (Misc queries) | |||
| Counting rows of blanks across certain columns | New Users to Excel | |||
| Counting rows with 3 columns | Excel Worksheet Functions | |||
Threaded Mode
