Counting

Hello Suyeon,

Hope you enjoyed your Microsoft Excel courses with Best STL.

Thank you for your question regarding counting data.

I have taken your example and created a formula using the function COUNTIF. I have added a bit of Data Validation to create a drop-down list to choose the class from.

The formula I used looks like this:

=COUNTIF(H3:H16,G18)

I haven't been able as yet to work out how to count the companies with one class. I think that it could be done using VBA code. I will try to work this one out for you and come back to you later.

I have attached the file I created for your information.



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