database functions

[360in.]

New to the boards, have been working with excel 07 for a few months now but am strugglingl. Have a few questions and a proposition at the end.....

1. I'm trying to figure out which database function to use to count a specfic group in a category. For instance, on an employee payroll chart I'd like to count the # of people that are bilingual, and i have it set up in a column saying yes or no.

2. What function should I use to find the the average salary for women making over $45,000?

3. what functions or function to find the sum of the salary of people bilingual and have experience?

If there is anyone willing to take a look at my work so far and possibly complete the remaining part of the project for me I'd glady paypal you a small fee for your time/effort. I'm in a bit of a time constraint and don't think I can figure out everything by tomorrow. I can email the files if need be, or post them somewhere on the web. thanks