matchrocket
New Member
- Joined
- Jun 24, 2016
- Messages
- 2
I have project I'm working on where I need to look at a specific (non changing) range of cells, and count specific instances of certain text while ignoring blanks.
The Ignoring blanks part is critical, as some of the text I'm searching for may not be in this range, and that's OKAY. Example of what I am trying to do is below:
For example in the first row:
If I wanted to count the number of A's, I would normally do =countif(<range>,"A"). But in this case, I want to search only the rows with text (non-blanks). So the range would be 6 rows, vs the 12 based on isn't blank.
I honestly can't figure out how to do this. I am on office 365.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]X[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
The Ignoring blanks part is critical, as some of the text I'm searching for may not be in this range, and that's OKAY. Example of what I am trying to do is below:
For example in the first row:
If I wanted to count the number of A's, I would normally do =countif(<range>,"A"). But in this case, I want to search only the rows with text (non-blanks). So the range would be 6 rows, vs the 12 based on isn't blank.
I honestly can't figure out how to do this. I am on office 365.
[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD]A[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]B[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]X[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]