i got a if formula for standard deviation but i got always an error
=ArrayFormula((STABWN(Berechnungen!C9:C10865;WENN(Berechnungen!A9:A10865">="&DATUM(G4;F4;E4);Berechnungen!A9:A10865"<="&DATUM(G5;F5;E5)))))
so thats the formula above. so its standarddeviation and then the fields with all standarddeviation results from c9 to c10865; next is if function(wenn) that says if the date fields in A9 until A10865 is bigger or equal then the date field that i can enter in the fields G4, F4 and E4 and then the date field again which should be smaller then that what i enter in that field.
Bookmarks