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