Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Formula to Next Row
I'm working on summarizing data from a survey. On the summary I need to
refer back to a worksheet that lists all responses in 28 columns (each column represents a question). I am hoping to set up a macro/formula that will count the number of responses for each question without having to retype the =counta formula for each column... Similarly, I need a formula which averages each question's responses without having to retype the =average formula for every column. Any help is appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
Auto fill of formula | Excel Worksheet Functions | |||
Formula for Auto filter | Excel Discussion (Misc queries) | |||
Auto Insert/Auto Formula? | Excel Worksheet Functions | |||
auto sum in formula | Excel Worksheet Functions |