Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
Auto fill of formula ksr Excel Worksheet Functions 7 June 6th 06 05:46 PM
Formula for Auto filter Mike Busch Excel Discussion (Misc queries) 1 March 15th 06 06:41 PM
Auto Insert/Auto Formula? Abacus Excel Worksheet Functions 1 February 3rd 06 11:33 AM
auto sum in formula hbpvs Excel Worksheet Functions 5 December 21st 04 12:34 PM


All times are GMT +1. The time now is 02:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"