+ Reply to Thread
Results 1 to 2 of 2

Averaging data in one column corresponding to specific names in another column

  1. #1
    Registered User
    Join Date
    09-30-2007
    Posts
    1

    Averaging data in one column corresponding to specific names in another column

    What formula can I use to average a random selection of numbers in one column that correspond specifically to a name or number in another column. Example: If column A contains the months of the year and there are many years in the list how can I average all the numbers in column B that correspond to a specific month?

    Thanks for your help

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    If column A just contains months in text format, i.e. not dates but entries like "March", "September" etc. then you could try something like

    =SUMIF(A:A,"September",B:B)/COUNTIF(A:A,"September)

    If you have actual dates in column A

    =SUMPRODUCT((MONTH(A1:A100)=9)+0,B1:B100)/SUMPRODUCT((MONTH(A1:A100)=9)+0)

    or you could use "array" formulas which need to be confirmed with CTRL+SHIFT+ENTER, e.g.

    =AVERAGE(IF(MONTH(A1:A100)=9,B1:B100))

    adjust ranges as necessary

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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