KuraiChikara
Board Regular
- Joined
- Nov 16, 2016
- Messages
- 111
- Office Version
- 2013
- Platform
- Windows
Hello,
I am trying to count cells if they are not blank without including extra rows or columns to do so.
I know how to represent if a cell is not blank but I do not know how to count them.
Example:
In the grid below A1 has my header and A2-A5 has a 1 or it doesnt.
B1 has my header and B2-B5 has my formula.
The formula I'm using basically says "IF A2 is not blank put "NOT BLANK" or put "BLANK" and it works.
=IF(A2<>"","NOT BLANK","BLANK")
Now from here, I could use another column to simply count, "Blank or Not Blank" but I don't want to do that.
The same formula does not work if I try to use "COUNTIF" this formula =COUNTIF(A2:A5,<>"") does not work
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Value
[/TD]
[TD="align: center"]Formula[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]NOT BLANK[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]BLANK[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]NOT BLANK[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]NOT BLANK[/TD]
[/TR]
</tbody>[/TABLE]
I am trying to count cells if they are not blank without including extra rows or columns to do so.
I know how to represent if a cell is not blank but I do not know how to count them.
Example:
In the grid below A1 has my header and A2-A5 has a 1 or it doesnt.
B1 has my header and B2-B5 has my formula.
The formula I'm using basically says "IF A2 is not blank put "NOT BLANK" or put "BLANK" and it works.
=IF(A2<>"","NOT BLANK","BLANK")
Now from here, I could use another column to simply count, "Blank or Not Blank" but I don't want to do that.
The same formula does not work if I try to use "COUNTIF" this formula =COUNTIF(A2:A5,<>"") does not work
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD="align: center"]Value
[/TD]
[TD="align: center"]Formula[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]NOT BLANK[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]BLANK[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]NOT BLANK[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]NOT BLANK[/TD]
[/TR]
</tbody>[/TABLE]