Hi, I'm trying to create a formula that will make a standard deviation of all the data in the column IF the date in same row is between specific dates: B2 and C2.
Iv'e used CTRL+SHIFT+ENTER for the formula to make it a range-formula
It returns wrong value
See file attachement
{=STDEV.S(IF((נתונים[תאריך הבדיקה]>=טווח[תאריך התחלה])*(נתונים[תאריך הבדיקה]<=טווח[תאריך סיום]),B$6:B$34))}
thank you.
Bookmarks