jeudi 14 janvier 2021

Excel Function STDEV.P IF AND Nested Equation #VALUE

I'm attempting to run a STDEV.P on a specific population that has 2 criteria. I did this with AVERAGEIFS and it worked perfectly.

Here's the equation I have:

{=STDEV.P(IF((Adjusted_Player_Data!A:A=Sim_FG!A3,Adjusted_Player_Data!AK:AK=SImulated_Outcome!H3),Adjusted_Player_Data!K:K,""))}

Adjusted_Player_Data!A:A is a player name list
Sim_FG!A3 is the player I'm looking up
Player_Data!AK:AK is the scale names (Low, Med, High)
Simluated_Outcome!H3 is the scale I am trying to match. 
Adjusted!K:K is the range I am running the STDEV.P against. 

Basically I need to match player and scale from big list. My averageifs function works perfectly and this is what it is: =AVERAGEIFS(Adjusted_Player_Data!K:K,Adjusted_Player_Data!A:A,Sim_FG!A3,Adjusted_Player_Data!AK:AK,SImulated_Outcome!H3)

Aucun commentaire:

Enregistrer un commentaire