I redesigned the sheet a bit to avoid this problem. It's a bit simpler and
strait forward now.

thanks for trying though!

"Peo Sjoblom" wrote:

=SUMPRODUCT(--(P_Range="hot"),--(T_Range="water"))

replace the fictional P and T ranges in my example with your real ranges
i.e. A2:A100 etc


--
Regards,

Peo Sjoblom


"ouch" wrote in message
...
ok, heres an example:
P T
hot water
hot milk
hot water
cold water
hot milk
cold milk
cold milk
hot water

So in this example I would want to know how many occurances of hot water
there was and how many times Cold milk occured in this list. The results
would then be on a seperate worksheet with a label above the values found.

Sounds simple enough, but... :)

"PCLIVE" wrote:

Give us an example of your data in columns P and T, in addition to what
type
of output you're looking for.


"ouch" wrote in message
...
Ok I tried both formulas and niether seem to work. Match stops at the
first
instance found and the other returns nothing but False even if the
criteria
matches. Perhaps it's meant for numbers only?

Any other ideas or should I make a VB macro to handle this?

Also this formula needs to run from a single cell.

Thanks for the help so far folks!

"ouch" wrote:

ok in column T I have a value that needs to be counted if it matches a
name.
However it also needs to match a name in column P.

Anyideas on how I could accomplish this?

thanks in advance.