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.
I have been trying to use wildcards, but they only seem to work for text and not numbers.
Thanks in advance.
View best response
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:
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
For newer versions of Excel try: