Averaging a set of values based off another set of values

New Contributor


I have a set of values in one column and another in the next column over (see image). I want to average the values in column B when there is a number in column A.Screen Shot 2019-02-23 at 11.06.48 AM.png

I have been trying to use wildcards, but they only seem to work for text and not numbers.

Thanks in advance.

3 Replies
Best Response confirmed by broccoli (New Contributor)



Do you want to calculate the average for only the number in column B that has a corresponding number in column A?


If this is what you want, please try this:


 AVERAGE with IF conditions.png


Please note that you need to press Ctrl+Shift+Enter to enter this formula not only Enter because it's an array formula.


Hope that helps

Exactly what I meant. Thank you :)

For newer versions of Excel try: