mercredi 5 août 2015

calculate standard deviation by month

I am trying to calculate stadard deviation by month from daily data. I used this function and it's not working.

{=STDEV.S(IF(AND(MONTH(data!$A$5:$A$3893)=MONTH($I22),YEAR(data!$A$5:$A$3893)=YEAR($I22)),data!H$5:H$3893,0))}

Can you help me about this?

Thanks

Aucun commentaire:

Enregistrer un commentaire