You have another thread active. Was that sufficient?

FPJ wrote:

That works but I also want to count the other codes that start with 1 (i.e.
1-PAS, 1-DEL, 1-HOM) that occured in January. Thanks.

"Tom Ogilvy" wrote:

=SUMPRODUCT(--(D1:D100="1-UCF"),--(TEXT(B1:B100,"mmm yy")="Jan
06"))

--
Regards,
Tom Ogilvy


"FPJ" wrote:

The first formula is OK but what if there were also 2-UCF that occured in
Feb., say.....Feb. 10 and Feb. 12 both had 1-UCF codes. And I want to count
the number of occurences of the codes that begin with #1 that were generated
in Jan. only.

Thanks.

"daddylonglegs" wrote:


OK, it works OK for me, perhaps you have additional charaters in the
data or the dates aren't being recognised as such.

What results do you get for

=SUMPRODUCT(--(RIGHT(D1:D100,3)="UCF))

and

=SUMPRODUCT(--(TEXT(B1:B100,"mmm yy")="Jan 06"))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=574293



--

Dave Peterson