Hi
Im trying to work out the Standard deviation of a result. Here is the formula i am using to extract the correct data from a column. This formula also works out the average of the extracted data:
=IF('Clearence Status sheet'!$J$1>=C3, AVERAGE(IF(('Clearence Status sheet'!$Q$1:$Q$999>=B3)*('Clearence Status sheet'!$Q$1:$Q$999<=C3)*('Clearence Status sheet'!$W$1:$W$999<=1000),'Clearence Status sheet'!$W$1:$W$999)), "not month end")
How do i add stdev to this formula?
note: b3 and c3 are dates (shown as numbers)
any help would be appreciated
Rob cunliffe
Bookmarks