I have a data table which looks something like this:

Ref Department Type
ENQ007740 Yellow Team AIR
ENQ007740 Yellow Team SEA
ENQ007745 Yellow Team SEA
ENQ007746 Red Team AIR
ENQ007748 Green Team AIR
ENQ007748 Green Team SEA

I want to count the number of enquiries by team.

So if I do this manually I would get:

Yellow 2
Red 1
Green 1

But if I use a pivot then I get:

Yellow 3
Red 1
Green 2

Because it can't recognise that some of the references are the same.

How can I get it to count discrete references only?

Thanks