I am currently using the formula =subtotal(102,"":"") to count non-blank cells that contain a numerical value.
When I try to use the same formula in cells that contain text I receive a "0".
Is it possible to count non-blank cells that contain text? The formula also needs to work when the column filter is on.
Please advise
When I try to use the same formula in cells that contain text I receive a "0".
Is it possible to count non-blank cells that contain text? The formula also needs to work when the column filter is on.
Please advise