I would like to make EXCEL count my teachers

Hi, I Want the excel to show me How many Math Teachers I have total at the school each day.
For Example: On sunday(R17) it needs to show the number "4" since i have 4 math teachers at total.

4292512.jpg
http://www.interload.co.il/upload/8860351.jpg

https://www.excelforum.com/attachmen...1&d=1517928403

thanks for helpers

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Explain in your thread title what you are trying to do, e.g. How do I count how many of my teachers are maths teachers?

EDIT: It's fine now - thank you.

Originally Posted by Jonmo1

Maybe COUNTA ?

=COUNTA(R7:R14)

If that's not what you're looking for, try attaching an actual workbook. Pictures aren't very helpful because we can't copy/paste your data into our own books to work with.

COUNTA Would do but if i'll insert a teacher that doesn't teach Match it will count him as well.
For example: if i'll add Teacher #6 that teaches only History it will count her and would make total teachers of 5 instead of 4.

here's the excel file : https://www.excelforum.com/attachmen...1&d=1517928403

Please attach the file HERE. Not everybody is able to access file-sharing sites.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.