Sumifs??

[pmpalma]

Trying to get an average from two disctinct arrays when two conditions exist

For instance

=IF(SUM(WP6:XY6,YD6:YL6)>0,AVERAGE(WP6:XY6,YD6:YL6),"")

Which is fine, but I would like it to work when WP4:XY4 AND YD4:YL4 = to either CC or AB

Can someone please help out??

I've been banging my head on this bloody desk for the past three hours to no avail

Thx

 

[Marcelo Branco]

See if this example helps

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

1​

Result​

2​

7​

3​

4​

AB​

AC​

CC​

CB​

CC​

CC​

AB​

AC​

CC​

CB​

CB​

CC​

5​

6​

3​

10​

8​

5​

4​

3​

10​

2​

12​

10​

8​

9​

7​

Formula in B2
=IF(SUM(B6:G6,I6:N6)>0,SUM(SUMIF(B4:G4,{"AB";"CC"},B6:G6),SUMIF(I4:N4,{"AB";"CC"},I6:N6))/SUM(COUNTIF(B4:G4,{"AB";"CC"}),COUNTIF(I4:N4,{"AB";"CC"})),"")

M.