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@stl-training.co.uk



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