Count if The value is over a certain amount and another column contains certain text

[jamesfry1]

Hi,

I have a worksheet where

Column D lists a service offered by a business, such as IMC, TC, Respite, etc

Column M lists how long the customer has used this service for in weeks, such as 4,5,3.5,6 etc

What I would like to do in another column is to count the number of clients who have used the service for 6 weeks or more broken down by the service type i.e. Count how many people have used IMC for 6 weeks or more.

If possible I would also like to be able to count those who have used a service for between 5.1. and 5.9 weeks too, again by service i.e. Count how many people have used IMC for between 5.1. and 5.9 weeks.

Any time and help on this would be greatly appreciated as it has been driving me mad!

Thanks

James

 

[Momentman]

I haven't fully pictured your request, but i think a pivot table and a filter might be your way out

 

[jamesfry1]

I haven't fully pictured your request, but i think a pivot table and a filter might be your way out

I had considered that but my issue is that the data will be live and continually updated and I need the above information to be available for a number of people to access instantly if possible- my understanding is that the Pivot Table data will be static i.e. at time the table was produced and not dynamic, changing as the data is updated?