COUNT FUNCTION?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zakynthos - 09 May 2008 14:44 GMT

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?

Reply to this Message

Otto Moehrbach - 09 May 2008 14:53 GMT

A few examples of what you want counted and what you don't want counted
would be helpful. HTH Otto

> 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?

Reply to this Message

Zakynthos - 09 May 2008 15:03 GMT

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.

> A few examples of what you want counted and what you don't want counted
> would be helpful. HTH Otto
[quoted text clipped - 4 lines]
> > numerical
> > variables in Col B associated with the text variable in A?

Reply to this Message

Max - 09 May 2008 15:13 GMT

Something like this, in C7:
=SUMPRODUCT((A2:A7="Otto")*ISNUMBER(B2:B7))
Adapt the ranges to suit

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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?

Reply to this Message

Peo Sjoblom - 09 May 2008 15:14 GMT

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

Signature

Regards,

Peo Sjoblom

> Otto,
>
[quoted text clipped - 20 lines]
>> > numerical
>> > variables in Col B associated with the text variable in A?

Reply to this Message

Gaurav - 09 May 2008 15:15 GMT

maybe

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

> Otto,
>
[quoted text clipped - 20 lines]
>> > numerical
>> > variables in Col B associated with the text variable in A?

Reply to this Message