Adequate formule

[taoa]

A big hello to everyone,

I open this great door with modesty and submit to you my little question.
My data is on a private network,it is possible to obtain a simple structure with INDEX and SUMPRODUCT.

Many thanks in advance
cordially.

taoa.

 

[David Ocampo]

Please see the attached file. I used a combination of named ranges, along with a transpose function to get values D3 and E3 into an array within a SUMIFS function. Then, I wrapped it around an average array formula.

 

[taoa]

Hello David and thanks

but if D3 = ""
if E3 = R13
Equals 11

 

[NARAYANK991]

Hi ,

This is quite cumbersome , but it seems to work. Check thoroughly.

Narayan

 

[bosco_yip]

F3 formula :

=IFERROR(SUMPRODUCT(SUMIFS(data!B2:B13,data!B2:B13,">0",data!A2:A13,D3:E3)/SUMPRODUCT(COUNTIFS(data!B2:B13,">0",data!A2:A13,D3:E3))),"")

However please check : if cell A12, Change R21 to R18



then,

formula result : 7

Regards
Bosco

 

[taoa]

NARAYANK991 Hello and thank you.

it's perfect, thanks again to the relevance of your formula .
But is it possible to get the same result without adding column C.

 

[taoa]

Hello bosco_yip ,

This is the right answer.
Thank you to you and all the team for this generosity.
Thank you to David and NARAYANK 991 .