I'm trying to count Text in a range of cells..
=IF(ISNUMBER(B6),COUNTA(City!G6,City!J6,City!M6,City!P6,City!S6,City!V6,City!Y6),"")
But it Seems that COUNTA includes formulas too.. The cells also has a drop down list too.. When the user chooses a city from one of those cells I would like the formula just to total the occurences..
Thanks..
=IF(ISNUMBER(B6),COUNTA(City!G6,City!J6,City!M6,City!P6,City!S6,City!V6,City!Y6),"")
But it Seems that COUNTA includes formulas too.. The cells also has a drop down list too.. When the user chooses a city from one of those cells I would like the formula just to total the occurences..
Thanks..