Hi

You need SUMPRODUCT. Have a look here for some guidance and post back if you
need some more help.
http://www.contextures.com/xlFunctio...tml#SumProduct

Hope this helps.

Andy.

"brendalw" wrote in message
...
is there a form of countif that increments only if conditions are met in
two
(or more) columns? e.g., countif(colA = 1 and colB = 2)