"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