Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting | Excel Discussion (Misc queries) | |||
Counting | Excel Discussion (Misc queries) | |||
counting | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) |