Originally Posted by jclau00
try this...
=SUM(IF(A1:A4=2005,1,0)*IF(B1:B4="bronze",1,0)) then ctrl shft enter
the logic behind this is if both conditions are true, then 1 * 1 = 1 else it'll be = 0
but that wouldnt count anything. The final anser would be 1 or 0 right?
:wtc: