Bobby

look at SUMIF rather than COUNTIF

Regards

Trevor


"Bobby" wrote in message
...
I need to check for a value in column 1, and if true, count the value in
the
same row in column 3.

Is it possible or feasible with Countif, or should I loop through the
array
and set a counter etc.

Thanks