Hi!
Thanks for the feedback!
Next to IF, SUMPRODUCT may be the most versatile function!
Take a look here for some good stuff:
http://xldynamic.com/source/xld.SUMPRODUCT.html
Biff
-----Original Message-----
YES! That's it! Thanks ever so much, Biff. That seems to
work great.
I seem to have a tough time comprehending Sumproduct,
because it frequently
is used as my solution, but I often need help with it. I
must study it more.
Any good tutorials on it?
Thanks again.
"Biff" wrote in message
...
Hi!
So, what you want to do is count unique values that
meet a
criteria?
Try this:
=SUMPRODUCT((A1:A9<"")/COUNTIF(A1:A9,A1:A9&"")*
(B1:B9="yes"))
Biff
-----Original Message-----
I'm drawing a blank on how to do this. I need a formula
to count "Yes"
values per unique value in another colum. (see example)
In each record...
The first column (A) shows trip codes.
The second column (B) shows either "Yes" or blank.
I need a formula that counts all "Yes" values in column
B
per trip
code.
For example, using the data below, "2" would be the
answer because 2
trip codes corresponded to "Yes".
Trip Covered
tr-24 Yes
tr-24 Yes
tr-24 Yes
tr-50
tr-50
tr-16 Yes
tr-16 Yes
tr-16 Yes
tr-16 Yes
It might help to know when "Yes" appears in a record of
a
particular trip
code,
it appears in each record of that code. No mixing.
Excel 2002
Thanks for your help!
.
.