Hello all,

I have an Excel sheet with state and county data. Column C indicates which
state and Column D indicates which county in that state from Column D.

I want to write a formula for percentile (Percentile()) and standard
deviation (STDEVP()) to determine percentile and standard deviation for any
state or county that I choose. Since there are more than one state and one
county in the sheet, I don't know how to write those formula.

In Excel, there are formula like sumif() and countif() if I want to sum a
specific state or county or count the records of specific state or county. I
do not find similar formula to do the percentile and standard deviation.

Please help.

Thanks.