cycle average

[kkondrat1]

ok, here is my new dilemma:

I have two fields: Registration Date and Registration Approval Date

Column A------------ColumnB
Registration Date---Registration Approval Date
1/01/04------------1/04/04
1/02/04------------blank
1/03/04------------1/17/04
1/01/04------------1/07/04
1/01/04------------blank

I want to know the number approved per registration date.

I also need to know the AVG it takes from reg date to reg approval dat
(Only if a reg approval date is present).

for example
I need a summary that looks like this:
ColumnA-----------ColumnB--------ColumnC
Registration Date--#Approved------Avg cycle (days)
1/01/04-----------2----------------4.5
1/02/04-----------0----------------0
1/03/04-----------1----------------1

 

[Frank Kabel]

Hi
I would start with a pivot table for this

 

[Bob Phillips]

First part: =SUMPRODUCT(--(A1:A10=--("2004/04/01")))

Second: =SUMPRODUCT(--(B1:B10<>""),(B1:B10-A1:A10))/COUNTA(B1:B10)

change the range length to suit