Some Excel help please

[the-evaluator]

I have some data which looks similar to this:

It's a list of names and licenses that they have assigned to them. We're planning some changes which will mean everyone needs an additional license, let's call it license D. The way the pricing works is that it's more cost effective for those people with license A, B & C to take another product called license E as license E includes licneses A, B, C & D.

What I'd like to do is get a count of the number of people that currently have license type A, B & C assigned to them so that I can work out how many license type E's I need. In this example that number is 3 - person 1, person 3 & person 4.

The actual spread is quite varied so it isn't as simple as looking at, for example, the total number of license C's that we have.

I can't for the life of me think how to figure it out though, does anyone have any ideas?

 

[bazzabear]

Do you know how to use pivot tables?

Pretty sure you could do this fairly easily by using one - but I'm not good enough with them to take you through it - I just play about with them until I get what I need.

 

[dante6491]

Use the Count if function? https://exceljet.net/excel-functions/excel-countif-function

But otherwise a Pivot table will broadly do it automatically.

 

[the-evaluator]

Pivot tables, why didn't I think of that? Cheers, I'll give it a go.

 

[the-evaluator]

Sorted - 30 seconds with a pivot table and I had exactly what I needed.