[Solved] Question about conditional counting

[jznance]

Good day,

I am sorry if this question has been addressed before, I have done a search in what time I have available at work and could not find anything that specifically highlighted this concern.

My question comes from a need to count individuals and keep a running number of consecutive entries. Full disclosure, it is a tardy tracker for a school that has been maintained by hand up to this point, but I would like to automate the process.

So I would like to be able to have a master list by name and total count on one spread sheet. On another sheet I would like to be able to enter a name (by date) and have the total count on sheet 1 track the cumulative name entries on sheet 2.

Is it possible to have a conditional count based on name text entry?

Thank you all.

 

[shamimarita]

Hello Jznance,

Thank you for your question! You can achieve this in Excel using a combination of COUNTIF or COUNTIFS formulas to track and count entries based on names across different sheets.

Here’s how you can set it up:

Master List (Sheet 1):

• Have a list of names in one column (e.g., Column A).
• In the adjacent column (e.g., Column B), use the COUNTIF formula to count occurrences of each name from Sheet 2.
• The formula will look something like this:

=COUNTIF(Sheet2!A:A, A2)

This will count the number of times the name in A2 appears in Column A of Sheet 2.

Input Sheet (Sheet 2):

You can enter the names along with the date or any other details in the relevant columns. For each name entered, the COUNTIF formula in Sheet 1 will automatically update to reflect the cumulative count.

This will allow you to automate tracking the cumulative number of entries for each individual.

I hope this helps! Let me know if you need further clarification.

 

[jznance]

This is wonderful! Thank you so much for your help. I was able to get them to work. This will hopefully streamline the incoming tardy students well, and give back more class time. I appreciate your help

 

[shamimarita]

You are most welcome. Thanks for your feedback and appreciation. Keep helping each other.