98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Countif function
Countif function
Resolved · Low Priority · Version 2003
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
Mon 12 Oct 2009, 16:11Trainer Amanda said...
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
Thu 15 Oct 2009, 05:55Trainer Vijayalakshmi said...
RE: Countif function
You have Countifs function in 2007 where you can embed multiple cirterias....
Wed 21 Oct 2009: Automatically marked as resolved.
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. |
Excel tip:Freeze Rows and Columns to keep lables displayedYou can freeze rows and columns in your worksheet so they don't move. |
