Database functions??

I need some assistence with setting up some data sorting.

I have been struggling with getting the database functions "DAVERAGE" and "DSTDEVP" to work in the results table. The examples in the datbase help don't cover sufficient variations for me to sort out what to do.

What I am trying to do is to collect the average and standard deviation for A, B, C, D individually only when the CMD is greater than zero. I have been able to get this to work with some If conditions and manual manipulations. I'd like to have this set up so I can just paste in new sets of data, AND NOT have to manually manipulate the column sizes etc ... The data lists can vary in size.

Any thoughts on what equations I would use in the results table??

Thank you, John

Data
Set CMD Input
A 0 10
B 0 10.1
C 0 9.8
D 0 10
A 1 10.14
B 1 11
C 1 9.8
D 1 10
A 1 11
B 1 10.5
C 1 9.6
D 1 10

Results A B C D
Average
STDP