Complex Function

[Derek]

Here is what I'm trying to do:

I'm creating a log of specific occurrences (one row for
each occurrence entered).

ADate) CThis condition?)
01/08/04 Y

I need to count the total number of occurrences entered
into the log that have a January date in column A:, AND
that contain a "Y" in column C:.

I'm famliar with date formating and specific serial
numbers for dates, but I cant combine the two conditions
here to achieve a total for the entire log.

Thanks

 

[Andy B]

Derek

Try this:

=SUMPRODUCT((MONTH(A2:A200)=12)*(C2:C200="Y"))

Andy.

 

[Chris Leonard]

In column D:

=IF(AND(MONTH(A1)=1,C1="y"),1,0)

In Cell E1 =countif(D,1)

HTH

Chris

 

[Guest]

For what I had set up, that SUMPRODUCT formula did the
trick! Thanks a million guys.