I put your little table "New Open Fixed Closed" into cell F1 to I1 and
into F2 I put the formula:

=COUNTIF($B:$B,F1)

and then I filled it across to I2.

Cheers,
Jason Lepack


wrote:
Hello all:

I have a spreadsheet where I want to count the occurences of a value
on a certain date and then use the resulting information in a chart.

My spreadsheet looks someting like this:


Column *A* contains the ID of the defect
Column *B* contains the status
Column *E* contains the open date
Column *F* contains the closing date if closed.


An example spreadsheet would be:


123 Closed 05/12/2006 07/24/2006
100 Open 04/30/2006
125 Fixed 05/12/2006
180 New 09/22/2006
140 Closed 07/01/2006 07/24/2006


I would like to:


*a)* count the number of defects for each status on each date (answer
should be:

New Open Fixed Closed
1 1 1 2



Please help, as I have spent too much time on this already!

--