Help counting entries on another sheet
I am trying to count the amount of entries of another sheet that match the name of a row on my master sheet. I have tried to do something with count Ifs and match@row but have got a bit lost.
So on my master sheet i have the name Basingstoke, beside that i have added a column saying how many times this appears on my secondary sheet.
Can any one help with a formula that looks at the name in the master sheet row and then does a count?
Really appreciate any help.
Help Article Resources
Check out the Formula Handbook template!