Excel UDF to calculate STDEV IF
Posted on 2012-08-20
I have a large dataset and i am struggling with slow calculation times due to some big array formulae. As you can see the formula has a couple of slow calculating components: an Average IF and a STD IF array.
Can anyone provide me with some code for a UDF that will replicate:
1. an Average IF i.e. average of cells A1:A100 if cells B1:B100 = "Yes"
2. a STD IF i.e. stdev of a range of data in cells A1:A100 if the number is greater than zero