B
bakerca
In Excel (Office Pro 2003), I am trying to write a formula that counts the
number of cells that contain a specific criteria (eg number of cells
containing the text "No stock"). This is straight forward until I use the
filter. When filtered, it continues to count all cells in the whole column,
not just the filtered range.
I'd appreciate a response if anyone knows how to do this.
number of cells that contain a specific criteria (eg number of cells
containing the text "No stock"). This is straight forward until I use the
filter. When filtered, it continues to count all cells in the whole column,
not just the filtered range.
I'd appreciate a response if anyone knows how to do this.