Summing text ouput in a column of formula

[Carideom]

Excel Issue: I've got columns of formulae. There is a reference column of text values (they happen to be model numbers). The formula cell examines the model number cell, and, if one of the criteria in the formula cell is 'met', the appropriate text value is written to the target cell (formula cell). If none of the criteria are met, the cell writes a 'space', or CHAR(32) in the target cell. I then take these 15, or so, columns of over 10,000 rows of formula cells and create a 'Table' so that 'counting' at the bottom of each column is handled quite nicely by the 'SUMTOTAL' function. This is all well and good except for one thing, when I attempt to 'count' the cells in a given column that exhibit visible 'text', indicating that one of the criteria have been met, the 'SUMTOTAL' formula counts ALL the cells, including those with "space" written in them. I want to count only the cells with "visible text"!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Can someone tell me how to stop counting the formula cells "displaying" the CHAR(32) (space) character?

 

[zookeepertx]

Instead of a space (Char(32)) if no criteria are met, put "" in the formula. That leaves the cell empty, so it shouldn't be counted. (I'm pretty sure, LOL)

Jenny

If none of the criteria are met, the cell writes a 'space', or CHAR(32) in the target cell.
Can someone tell me how to stop counting the formula cells "displaying" the CHAR(32) (space) character?