I have a column of subtotals, and need to eliminate all cells were the
subtotal is 1, and then calculate the mean and SD of the remaining subtotals
left in the column.

What is the best way to go about setting this up in a spreadsheet and what
formula do I use to get rid of the 1's?

Cheers,
Katie