+ Reply to Thread
Results 1 to 2 of 2

Count and Average based on a column value

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    97

    Count and Average based on a column value

    Please see attached.

    As you find in the summary (Column S) I am trying to figure out a way to do a count and average in Columns (E,G,I,K,M,O,Q) based on Column A. In other words for 1-Count, Count all values in Columns (E,G,I,K,M,O,Q) where Column A equals 1 and same goes for Average.

    Dates are used for something else, ignore dates for these calculations.

    The values in the summary are correct and what I am trying to achieve automatically.

    Thanks so much in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Count and Average based on a column value

    Hello
    This is a formula solution not VBA but SUMPRODUCT might work well here, for example for the 'Counts':

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    And for the 'Averages':

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You will have to adjust the 'S' row reference accordingly.

    Hope this helps.
    DBY

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] count and average numbers based off date, not worksheet data is in
    By nicki_rae22 in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 05-13-2015, 03:34 PM
  2. Need to calculate average for a column based on moving start column
    By BonnD in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 08:35 AM
  3. [SOLVED] Find average of column b based on boundaries applied to column a
    By Kybynn in forum Excel General
    Replies: 1
    Last Post: 12-04-2012, 07:17 AM
  4. Display Average, Count and Sum for 4 column at the last row after filter
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-08-2012, 01:49 AM
  5. Replies: 2
    Last Post: 06-25-2012, 11:21 PM
  6. Replies: 8
    Last Post: 02-16-2011, 05:03 PM
  7. Replies: 2
    Last Post: 01-28-2011, 12:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1