=sumproduct(-(A1:A10000="Approved"),-(B1:B10000="Insurance"))

"esmer" wrote:

I need to count two columns in the same worksheet. Example count if columnA
eq approved and columnB eq insurance then count?