Forum home » Delegate support and help forum » Microsoft Excel Training and help » Countif function
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Countif function
Resolved · Low Priority · Version 2003
Reply Mon 12 Oct 2009, 09:51Delegate Karen said...
Karen has attended:
Excel Advanced course
Countif function
Is there a way you can do a countif function with 2 criteria?
I have used a sumif array formula using the conditional sum wizard but I know need to do a countif with the same criteria.
Thanks
For upcoming training course dates see: Pricing & availability
RE: 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
RE: Countif function
You have Countifs function in 2007 where you can embed multiple cirterias....
Wed 21 Oct 2009: Automatically marked as resolved.
|