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?

A few examples of what you want counted and what you don't want counted
would be helpful. HTH Otto
"Zakynthos" wrote in message
...
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,

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" wrote in message
...
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?

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?

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


--


Regards,


Peo Sjoblom


"Zakynthos" wrote in message
...
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" wrote in message
...
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?

maybe

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


"Zakynthos" wrote in message
...
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" wrote in message
...
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?