Countif function

Hello Karen

Thank you for your question.

You could use either of the database functions DCOUNT or DCOUNTA, which should have been covered on the Excel Advanced course you attended with us.

Alternatively when you filter a database, you will see in the status bar at the bottom left of the screen, Excel will tell you the number of records in the database that match your filtering criteria.

I hope this helps.

Kind regards
Amanda

You have Countifs function in 2007 where you can embed multiple cirterias....