I need a cell to populate as a one when 2 cells meet criteria
 

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

I need a cell to populate as a one when 2 cells meet criteria
 

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

I need a cell to populate as a one when 2 cells meet criteria
 

Look in the help index for AND & IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Loren71" wrote in message
...
I am looking for a cell to add each time two cells in two different
collomns
meet certian criteria