I have two columns of data and I want to count the number of times where condition1 AND condition2 are true. Column 1 contains dates in dd.mm.yyyy format, column 2 contains text. I am looking for the occurences of "accepted" that occur before a specific date.
=SUM(IF((D25:D32="accepted")*(A25:A32<"01.02.2002");1;0))
does not work nor does
=SUM(IF(D25:D32="accepted",IF(A25:A32<"01.02.2002",1,0),0))
any ideas?
-P
=SUM(IF((D25:D32="accepted")*(A25:A32<"01.02.2002");1;0))
does not work nor does
=SUM(IF(D25:D32="accepted",IF(A25:A32<"01.02.2002",1,0),0))
any ideas?
-P