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