G
Guest
I have a column where I'm using IF statements to return a value from another
column if certain conditions are meet and "" otherwise. Previously I had
manually enter that information and then did a count of any cell in that
column, using COUNTA, that contain a value. But, since changing to an if
statement, COUNTA is counting every cell because every cell now has an if
statement in it. I want to count cells only when the if statement returns a
value other than "" (blank).
How do I do this?
Here's my data
ColA ColB
1A =if(right(A1,1)="A",A1,"")
2C =if(right(A1,1)="A",A1,"")
3D =if(right(A1,1)="A",A1,"")
4E =if(right(A1,1)="A",A1,"")
5W =if(right(A1,1)="A",A1,"")
=countA(b1:b5)
column if certain conditions are meet and "" otherwise. Previously I had
manually enter that information and then did a count of any cell in that
column, using COUNTA, that contain a value. But, since changing to an if
statement, COUNTA is counting every cell because every cell now has an if
statement in it. I want to count cells only when the if statement returns a
value other than "" (blank).
How do I do this?
Here's my data
ColA ColB
1A =if(right(A1,1)="A",A1,"")
2C =if(right(A1,1)="A",A1,"")
3D =if(right(A1,1)="A",A1,"")
4E =if(right(A1,1)="A",A1,"")
5W =if(right(A1,1)="A",A1,"")
=countA(b1:b5)