Macro which can countif on multiple criteria and export result

Closed
Chiara666
Posts
1
Registration date
Wednesday January 16, 2013
Status
Member
Last seen
January 16, 2013
- Jan 16, 2013 at 04:51 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Jan 16, 2013 at 06:16 AM
Hello,

I have to create a macro, which can count for me how many of different categories of services we have.
there are around 20 main categories and 2 subcategories. So eg i have to make the macro count how many of the category AM-AM, with the state *candidate* with the suffix s
The result should be exported to another sheet.
Please help me. I really tried everything
I am working in excel 2003

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Jan 16, 2013 at 06:16 AM
could you post a sample book at some public file sharing site like speedyshare and post back link to the actual file back here. Using that file as basis please re-explain what you seek
0