Countif, counta

[DataMngr]

I want to count the cells that have the word "Select" in column E if the cells in column A aren't blank. Can anyone help me with this? Thank you... I just can't seem to figure out the right formula.

 

[Yourself93]

=IF(A2=" "," ", COUNTIF(E2,"Select")) Tested this and it appeared to work assuming this is just an excel question and nothing vba cause then I am useless.

 

[FDibbins]

★ Yourself93, I think OP wants to count all instances of anything in E = Select and anything in A containing data (not just A2)

Try this...
=COUNTIFS($E$1:$E$10,"select",$F$1:$F$10,"<>")

 

[DataMngr]

Thank you! This worked great!