COUNT FUNCTION?

If Col A contains a text variable and column B contains a numerical variable
associated with the text variable, what is the simplest formula I can put
into a single cell that will count the number of occurrences of the numerical
variables in Col B associated with the text variable in A?

Otto
Fri May 09 08:53:31 CDT 2008

A few examples of what you want counted and what you don't want counted
would be helpful. HTH Otto
"Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message
news:CC66B1FE-24A0-4DE8-9DF6-AB7A1E929A82@microsoft.com...
> If Col A contains a text variable and column B contains a numerical
> variable
> associated with the text variable, what is the simplest formula I can put
> into a single cell that will count the number of occurrences of the
> numerical
> variables in Col B associated with the text variable in A?

Zakynthos
Fri May 09 09:03:01 CDT 2008

Otto,

Say column A contains 3 occurrences of the name 'Otto' and Column B contains
sums of money associated with the name Otto, perhaps B2 has $2000, B4 $10000
and B7 $200000.

What formula could I input say to C7 that would return the answer '3' - i.e.
the number of values in Column B associated with the name 'Otto' in Column A?

Many thanks.

"Otto Moehrbach" wrote:

> A few examples of what you want counted and what you don't want counted
> would be helpful. HTH Otto
> "Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message
> news:CC66B1FE-24A0-4DE8-9DF6-AB7A1E929A82@microsoft.com...
> > If Col A contains a text variable and column B contains a numerical
> > variable
> > associated with the text variable, what is the simplest formula I can put
> > into a single cell that will count the number of occurrences of the
> > numerical
> > variables in Col B associated with the text variable in A?
>
>
>

demechanik
Fri May 09 09:13:01 CDT 2008

Something like this, in C7:
=SUMPRODUCT((A2:A7="Otto")*ISNUMBER(B2:B7))
Adapt the ranges to suit
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Zakynthos" wrote:
> Say column A contains 3 occurrences of the name 'Otto' and Column B contains
> sums of money associated with the name Otto, perhaps B2 has $2000, B4 $10000
> and B7 $200000.
>
> What formula could I input say to C7 that would return the answer '3' - i.e.
> the number of values in Column B associated with the name 'Otto' in Column A?

Gaurav
Fri May 09 09:15:07 CDT 2008

maybe

=SUMPRODUCT(--(A1:A10="otto"),--(B1:B10<>""))


"Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message
news:618B46AA-03F4-4CEE-BB40-54C733F42A1F@microsoft.com...
> Otto,
>
> Say column A contains 3 occurrences of the name 'Otto' and Column B
> contains
> sums of money associated with the name Otto, perhaps B2 has $2000, B4
> $10000
> and B7 $200000.
>
> What formula could I input say to C7 that would return the answer '3' -
> i.e.
> the number of values in Column B associated with the name 'Otto' in Column
> A?
>
> Many thanks.
>
> "Otto Moehrbach" wrote:
>
>> A few examples of what you want counted and what you don't want counted
>> would be helpful. HTH Otto
>> "Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message
>> news:CC66B1FE-24A0-4DE8-9DF6-AB7A1E929A82@microsoft.com...
>> > If Col A contains a text variable and column B contains a numerical
>> > variable
>> > associated with the text variable, what is the simplest formula I can
>> > put
>> > into a single cell that will count the number of occurrences of the
>> > numerical
>> > variables in Col B associated with the text variable in A?
>>
>>
>>

Peo
Fri May 09 09:14:41 CDT 2008

=SUMPRODUCT(--(A2:A100="Otto"),--(ISNUMBER(B2:B100)))


--


Regards,


Peo Sjoblom


"Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message
news:618B46AA-03F4-4CEE-BB40-54C733F42A1F@microsoft.com...
> Otto,
>
> Say column A contains 3 occurrences of the name 'Otto' and Column B
> contains
> sums of money associated with the name Otto, perhaps B2 has $2000, B4
> $10000
> and B7 $200000.
>
> What formula could I input say to C7 that would return the answer '3' -
> i.e.
> the number of values in Column B associated with the name 'Otto' in Column
> A?
>
> Many thanks.
>
> "Otto Moehrbach" wrote:
>
>> A few examples of what you want counted and what you don't want counted
>> would be helpful. HTH Otto
>> "Zakynthos" <Zakynthos@discussions.microsoft.com> wrote in message
>> news:CC66B1FE-24A0-4DE8-9DF6-AB7A1E929A82@microsoft.com...
>> > If Col A contains a text variable and column B contains a numerical
>> > variable
>> > associated with the text variable, what is the simplest formula I can
>> > put
>> > into a single cell that will count the number of occurrences of the
>> > numerical
>> > variables in Col B associated with the text variable in A?
>>
>>
>>