AdyStewart
New Member
- Joined
- Jun 29, 2019
- Messages
- 6
Hello
i need a formula that will count the number of rows in an range B3:G9 that has any of letters in column H in
Example: The formula should return the Value 3 because 3 rows has one of the letters in that row
i did find this but i cant get it to work for me {=SUM(--(MMULT(--(B3:G9="H"),TRANSPOSE(COLUMN(B3:G9)))>0))}
<tbody>
</tbody>
i need a formula that will count the number of rows in an range B3:G9 that has any of letters in column H in
Example: The formula should return the Value 3 because 3 rows has one of the letters in that row
i did find this but i cant get it to work for me {=SUM(--(MMULT(--(B3:G9="H"),TRANSPOSE(COLUMN(B3:G9)))>0))}
Date | 30/06/2019 | 01/07/2019 | 02/07/2019 | 03/07/2019 | 04/07/2019 | 05/07/2019 | 06/07/2019 | Letters to count | ||
Name | Sun | Mon | TUE | WED | THU | FRI | SAT | |||
Bill | H | H | UH | UH | ||||||
Bob | CO | CO | T | |||||||
Steve | H | |||||||||
Jill | T | T | T | |||||||
June | ||||||||||
Becky | ||||||||||
Scott | HA | HP |
<tbody>
</tbody>