+ Reply to Thread
Results 1 to 6 of 6

wildcare formula?

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    Liverpool, England
    MS-Off Ver
    2003, 2007, 2010 (main)
    Posts
    26

    wildcare formula?

    hi all

    im looking to average the amount of calls we receive based on what day the calls were made.

    Attached is a copy of the table i am using.

    im looking to add up all the calls we received on a Monday and then average it for the amount of Mondays we have collected the data.

    if i haven't explained this well im sorry just reply and i will hopefully be able to explain it better

    P.S. i know this could be done by manually selecting the cells and then averaging them however this would be unsuitable as the data range is going to keep growing

    thanks

    michael
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,406

    Re: wildcare formula?

    How about Pivot Table?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-15-2014
    Location
    Liverpool, England
    MS-Off Ver
    2003, 2007, 2010 (main)
    Posts
    26

    Re: wildcare formula?

    hmm never used or heard of a pivot table ill research around them now. thanks

  4. #4
    Registered User
    Join Date
    07-09-2014
    Location
    Indianapolis, Indiana, USA
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: wildcare formula?

    Great idea on the Pivot Table option! Here's one that is a bit clearer and I think gets you what you're looking for. There are other ways to do this too if you're interested!
    Attached Files Attached Files

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: wildcare formula?

    Like this...

    K2 = Monday

    =AVERAGEIF(A:A,K2,E:E)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  6. #6
    Registered User
    Join Date
    06-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    22

    Re: wildcare formula?

    The working is shown in the attachment.

    Regards,
    K. Vikas
    Attached Files Attached Files

+ 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. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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