Seeing Chuck's suggestion made me realise that I had misread the request:

=SUMPRODUCT(--(A1:A5<""),--(LEFT(D1:D5,3)<"HUD"))

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"Sandy Mann" wrote in message
...
"KL" wrote in message
...
Hi vipa,

Try this:

=COUNT($A$2:$A$6)-COUNTIF($D$2:$D$6,"HUD*")

Assumes that every entry in column D with "Hud*" has a corresponding entry
in Column A which may or may not be true. I would suggest:

=SUMPRODUCT(--(A1:A5<""),--(LEFT(D1:D5,3)="HUD"))
--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk