You're welcome. Thanks for the feedback!

Biff

"UT" <UT@discussions.microsoft.com> wrote in message
news:9A59965D-56B7-4FC4-95A2-2A9835459080@microsoft.com...
> Hi Biff,
>
> The formula worked. Thanks a lot.
>
> "Biff" wrote:
>
>> Hi!
>>
>> Take a look at this screencap:
>>
>> http://img526.imageshack.us/img526/1241/sump0mi.jpg
>>
>> If you're getting a result of 3 based on your example then the "blank"
>> cell
>> is not blank. Is there a formula in the second column? There may be
>> unseen
>> characters like spaces.
>>
>> As you can see in the screencap the formula does return the correct
>> result.
>>
>> Biff
>>
>> "UT" <UT@discussions.microsoft.com> wrote in message
>> news:375087DF-16C0-48CC-9BDC-036C1F3C756F@microsoft.com...
>> > Hi Biff,
>> >
>> > The function dosent work. It counts the number of entries in Column A .
>> > So
>> > it gives me count of 3 in the example below. But it should actually
>> > show
>> > the
>> > count of 2 since there are only two entries that match "ANTH 328". Any
>> > other
>> > guesses?
>> >
>> > "Biff" wrote:
>> >
>> >> Hi!
>> >>
>> >> Try this:
>> >>
>> >> =SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<>""))
>> >>
>> >> Biff
>> >>
>> >> "UT" <UT@discussions.microsoft.com> wrote in message
>> >> news:B990FEC0-72D8-435A-9C61-6FB9E22F8E89@microsoft.com...
>> >> >I need to count non blank cells that match a condition.
>> >> >
>> >> > For example i want to count number of entries in Column "B" for
>> >> > "ANTH
>> >> > 328"
>> >> > course.
>> >> >
>> >> > A B
>> >> > ANTH 328 PC
>> >> > ANTH 328
>> >> > ANTH 328 PC
>> >> >
>> >> > I have tried DCOUNTA and combination of functions. Nothing is
>> >> > working.
>> >> > Help
>> >> > will be greatly appreciated.
>> >>
>> >>
>> >>
>>
>>
>>