PDA

View Full Version : help with excel



roger
10-26-2005, 07:07 AM
I have a question about an excel project.

I need to track information for specific dates.

As an example I have a column of dates 1/02/05 and a column of pass or fail, what I need to do is compare the amount of pass and fails for each month. Like for the month of January I want to know how many failures I had.

Any help with this would be appreciated.

Bob Phillips
10-26-2005, 07:25 AM
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(B1:B100="Fail"))