Using Averageifs function in excel with multiple condition

Hi

I am not a Guru..but you can try, something like this.

=IF(COUNTIF(A:A;"A")+COUNTIF(A:A;"B")+COUNTIF(A:A;"C")>0;AVERAGE(B:B);"")

Hope to helps you

This regular formula averages the Col_B cells where the corresponding Col_A cell equals any of a, b, or e

Please Login or Register  to view this content.

Is that something you can work with?

..An example is here..

Originally Posted by xenos14

Thanks Ron,

How to use same example for countif?

In this part of the formula I posted:
SUM(COUNTIF(A:A,"="&{"a","b","e"}))

This section: "="&{"a","b","e"}
resolves to these three distinct criteria:
="a"
="b"
="e"
(The braces {} define the beginning and end of the array of values)

Consequently, this: SUM(COUNTIF(A:A,"="&{"a","b","e"}))
is equivalent to this:
SUM(COUNTIF(A:A,="a"),COUNTIF(A:A,="b"),COUNTIF(A:A,="e"))

I hope that helps

Consequently, this: SUM(COUNTIF(A:A,"="&{"a","b","e"}))
is equivalent to this:
SUM(COUNTIF(A:A,="a"),COUNTIF(A:A,="b"),COUNTIF(A:A,="e"))

Thanks Ron

First time see this...

I dIdn't knew this!