-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
count a number of classes for a teacher
- Thread starter aysam
- Start date
DanteAmor
Well-known Member
- Joined
- Dec 3, 2018
- Messages
- 18,077
- Office Version
- 2019
- Platform
- Windows
It's not clear to me where you want the result or what you want to count.
But I show you a formula to count how many "1/ 1" there are, check if it works for you.
----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --
But I show you a formula to count how many "1/ 1" there are, check if it works for you.
| varios 07sep2024.xlsm | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | |||
| 1 | ||||||||||||||||||||||||||||||
| 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||||||
| 3 | 1/ 1 | 1/ 1 | 2/ 2 | 2/ 2 | 1/ 1 | 1/ 1 | 8 | teacher 1 | ||||||||||||||||||||||
| 4 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | ||||||||||||||||||||||||
| 5 | 1/ 1 | 1/ 1 | 1/ 1 | 1/ 1 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | 2/ 2 | |||||||||||||||||||
| 6 | ||||||||||||||||||||||||||||||
| 7 | ||||||||||||||||||||||||||||||
| 8 | 2/ 2 | 2/ 2 | 2/ 2 | |||||||||||||||||||||||||||
| 9 | ||||||||||||||||||||||||||||||
| 10 | ||||||||||||||||||||||||||||||
Hoja2 | ||||||||||||||||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| Z3 | Z3 | =SUMPRODUCT((A3:X9="1/ 1")*1) |
----- --
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
----- --
Upvote
0
Similar threads
