Perhaps:

if just 2 cells:

=(A1="criterion1") + (B1="criterion2")

if comparing each row in two columns:

=SUMPRODUCT(--(A1:A100="criterion1"),--(B1:B100="criterion2"))

In article ,
Loren71 wrote:

I am looking for a cell to add each time two cells in two different collomns
meet certian criteria