That's what it does. Have you looked in HELP index for COUNTIF

--
Don Guillett
SalesAid Software

"jrm" wrote in message
...
Counting the number of occurances of a number if a condition is met in an
adjacent column on the same row