Conditional Averaging

[geddes_3]

I have three columns of data, one containing numerical values. I want to average the numbers based on the other two columns of data. Attached is an example file with the desired output I'd like. What is a formula that will do this? AverageExample.xlsx

[sktneer]

Try this.....

For Y Average

Please Login or Register  to view this content.

For N Average

Please Login or Register  to view this content.

[geddes_3]

Thanks, but I realized I gave a bad example. Not all the values in the other two columns are the same. Here's a better example: AverageExample2.xlsx So basically I need to average all values in column C that correspond to non-blank cells in columns A and B.

[sktneer]

What is your criteria for Y and N?

[geddes_3]

I forgot to change the Y and N on the new example. For the desired output, I need to average all the values in column C that correspond to non-blank values in column A and column B. All the cells in columns A and B contain unique individual values.

[sktneer]

Try these array formula, they need to be confirmed with Ctrl+Shift+Enter

For Y average

Please Login or Register  to view this content.

For N average

Please Login or Register  to view this content.

Remember to confirm both the formulas with Ctrl+Shift+Enter

[geddes_3]

Brilliant! That works great. Thank you!

[sktneer]

Glad to help you. Thanks for the feedback.