Counting Specific Criteria

[VTbigwillie]

There are three radio buttons to hold 3 different values (1,0,-1) and the selection goes into the table with one of those values. I need to count the number of instances of each of those values and then run a formula which counts all of the 1's and divides that number by the number of 1's and -1's. I can't seem to get access to let me query any data with that type of criteria.

I can run DCount to get the totals for the whole table but I need to be able to run that sort of formula on a wide range of criteria.

Is this possible?

Thanks in advance,
Will