Count the number of times a record has been used in a lookup

Count the number of times a record has been used in a lookup

Hi,

Is there a formula that I could use that would allow me to see how many times a record is used via the lookup field? Below is what I'm trying to create in each view.

View 1

Task #  |  Issue Type
Task 1  |  issueA
Task 2  |  issueB
Task 3  |  issueA
Task 4  |  issueA

*Issue Type is a lookup field where I select the type of issue from another view.


View 2

Issue Type |    Description   |  Count
issueA        |  Broken Pipe   |  3
issueB        |  Leaky faucet  |  1