Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
|
|
|
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. |
Excel
Resolved · Urgent Priority · Version 2003
Reply Thu 3 Nov 2011, 15:31Delegate Rachael said...
Rachael has attended:
Excel VBA Intro Intermediate course
Excel
Is there a way to calculate the number of cells that match a certain ciretria when the column has a filter on it?
E.g;
Row A has 25 "PAYE" workers in there, but when we select a filter in Row B the result is 5 "PAYE" workers. the countif still counts a total of 25, but we would like to be able to count only 5. Is this possible?
Thanks
Rac
For upcoming training course dates see: Pricing & availability
RE: Excel
Hello Rachael,
Hope you enjoyed your Microsoft Excel VBA course with Best STL.
Thank you for your question regarding working with filtered data and being able to either sum or count items that appear after the filter has been applied.
I have attached a small file containing some employee data and I have created a subtotal function for the paye column and the salary column. Since I applied a number of 1 to the paye employees and a 0 to the rest, the subtotal will always work no matter how you have filtered the list.
If this does not help you, then I suggest you send me a copy of your file to my email address at:
rl
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
Employee information.xlsThu 10 Nov 2011: Automatically marked as resolved.
|