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

=countif(a1:a22,"chp")


--
Markyboy
------------------------------------------------------------------------
Markyboy's Profile: http://www.excelforum.com/member.php...o&userid=29493
View this thread: http://www.excelforum.com/showthread...hreadid=498510

Such formulas do not admit whole column references:

1.

=COUNT(IF(MSL!$O$2:$O$300=1,IF(MSL!$D$2:$D$300="CH P",1)))

which needs to be confirmed with control+shift+enter, not just with enter.

2. Alternatively...

=SUMPRODUCT(--(MSL!$O$2:$O$300=1),--(MSL!$D$2:$D$300="CHP"))

which needs just enter.


VAN GOGH wrote:
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

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