Countif match

joshbrfc

New Member
Joined
Jan 17, 2022
Messages
25
Office Version
  1. 2016
Platform
  1. Windows
Hi all,

I want to count the quantity of entries in a row on a specific tab in a workbook based on the match of someones name.

So this is the master data tab.

1707828289178.png


Then i have separate tabs.

And i want it to match with the name cell and the quantity of data entries.

1707828275512.png



Hope that makes sense.

Would Lookup be better?

So it updates automatically when another data entry is added.

Any help greatly appreciated. It's part of trying to improve right first time :) Want a tracker to focus on who needs training more and quick overview.
 

Attachments

  • 1707828159604.png
    1707828159604.png
    2.4 KB · Views: 8
  • 1707828179629.png
    1707828179629.png
    3.9 KB · Views: 8
I cannot really say I understand what you are asking now, but it seems like it might be a whole different question anyway (from the original).
As such, it would be best to post it in a new thread so it shows up as a new question and people will see it on the "Unanswered threads" listing.
 
Upvote 0

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
I cannot really say I understand what you are asking now, but it seems like it might be a whole different question anyway (from the original).
As such, it would be best to post it in a new thread so it shows up as a new question and people will see it on the "Unanswered threads" listing.
Okay mate.

Thanks so much for your help.
 
Upvote 0

Forum statistics

Threads
1,215,076
Messages
6,122,988
Members
449,093
Latest member
Mr Hughes

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top