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

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?

2. 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))

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

#### 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