Prev: HELP! having trouble matching info with excel, HELP!
Next: Count function seeing formulas as data
From: robinessex on 6 Jun 2010 06:54
How can you get around the count function seeing formulas in any cell
referenced as data?
From: Bob Phillips on 6 Jun 2010 07:51
I don't think COUNT will, COUNT yes, but not COUNT unless it returns a
number.

Give an example.

--

HTH

Bob

"robinessex" <robinessex(a)discussions.microsoft.com> wrote in message
news:A729CA67-E421-49C1-8850-7E9AA24D0DE8(a)microsoft.com...
> How can you get around the count function seeing formulas in any cell
> referenced as data?


From: Mike H on 6 Jun 2010 07:59
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?
From: Dave Peterson on 6 Jun 2010 08:40
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" <robinessex(a)discussions.microsoft.com> wrote in message
> news:A729CA67-E421-49C1-8850-7E9AA24D0DE8(a)microsoft.com...
> > How can you get around the count function seeing formulas in any cell
> > referenced as data?

--

Dave Peterson
From: Mike H on 6 Jun 2010 09:12
Hi,

You could have responded to the 2 answers you have in your other thread.
COUNT is not a useless formula, it is excellent at what it was designed to do
and that is COUNT things and you'll get no support for this suggestion.

If your tring to count a particular type of string or number then the
excellent COUNTIF is maybe what you require and there is a full description
of how it works in Excel Help, as there is also for COUNT.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"robinessex" wrote:

> Can you change the count function seeing formulas in cells as data. This
> makes the function completely useless. I have an array 1000 cells X 500
> cells. I need the count function to check on the number of occurances a
> particular value is exceeded. The data is read into each of these cells by a
> formula.
>
> ----------------
> This post is a suggestion for Microsoft, and Microsoft responds to the
> suggestions with the most votes. To vote for this suggestion, click the "I
> Agree" button in the message pane. If you do not see the button, follow this
> link to open the suggestion in the Microsoft Web-based Newsreader and then
> click "I Agree" in the message pane.
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=11902c96-1351-4d20-b30b-dcb7837023c4&dg=microsoft.public.excel.worksheet.functions
 |  Next  |  Last
Pages: 1 2
Prev: HELP! having trouble matching info with excel, HELP!
Next: Count function seeing formulas as data