Count function seeing formulas as data
How can you get around the count function seeing formulas in any cell
referenced as data? |
Count function seeing formulas as data
I don't think COUNT will, COUNT yes, but not COUNT unless it returns a
number. Give an example. -- HTH Bob "robinessex" wrote in message ... How can you get around the count function seeing formulas in any cell referenced as data? |
Count function seeing formulas as data
Hi,
I don't understand the question. Perhaps if you tell us what you are trying to count and the types of data in the cells being counted someone will help. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "robinessex" wrote: How can you get around the count function seeing formulas in any cell referenced as data? |
Count function seeing formulas as data
I'm sure Bob meant =CountA() will count cells with formulas.
=Count() will count cells with formulas if the formulas evaluate to a number. Bob Phillips wrote: I don't think COUNT will, COUNT yes, but not COUNT unless it returns a number. Give an example. -- HTH Bob "robinessex" wrote in message ... How can you get around the count function seeing formulas in any cell referenced as data? -- Dave Peterson |
Quote:
counta function counts the cells with formula cum data cells countblank function counts blank cells. all the best |
All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com