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?