I am looking for a cell to add each time two cells in two different collomns meet certian criteria
G Guest Sep 3, 2007 #1 I am looking for a cell to add each time two cells in two different collomns meet certian criteria
J JE McGimpsey Sep 3, 2007 #2 Perhaps: if just 2 cells: =(A1="criterion1") + (B1="criterion2") if comparing each row in two columns: =SUMPRODUCT(--(A1:A100="criterion1"),--(B1:B100="criterion2"))
Perhaps: if just 2 cells: =(A1="criterion1") + (B1="criterion2") if comparing each row in two columns: =SUMPRODUCT(--(A1:A100="criterion1"),--(B1:B100="criterion2"))