If that's all you want then this should do it

=countif(msl!d:d,"chp")

--
Don Guillett
SalesAid Software

"VAN GOGH" <VAN wrote in message
...
I'M TRYING TO GET A COUNT FROM A COLUMN D OF ALL THE TIMES "CHP" APPEARS
USING THE FOLLOWING FUNCTION

=COUNT(IF((MSL!O:O="1")*(MSL!D:D="CHP"),MSL!D:D))

I'M LOST...ANY HELP IS APPRECIATED