Hello,
I understand there is not a formula for std.if,
I am currently trying to build a tool to measure standard deviation of a column of data on a different sheet but only if it meets 2 parameters in the same row.
For example I have already calculated average ifs
=AVERAGEIFS(Data!$O13:$O40000, Data!$I13:$I40000, C9, Data!$P13:$P40000,$E$2)
Where Column O is the data I am looking to get average and std of, Column I is a parameter of 1-24 but is jumbled data, Column P is a number 1-3
basically trying to calculate the avg and std of
setting 1 - 1
setting 1 - 2
setting 1 - 3
setting 2 - 1
etc up to
24-3
Any help is greatly appreciated.
Thanks.
Bookmarks