Good morning,

I have a workbook and my goal is to see when a number is no longer on the
sheet.

My workbook looks like this

A B
1 05/01/2007 25235
2 05/01/2007 68325
3 05/01/2007 78932
4 05/02/2007 68325
5 05/02/2007 11123
6 05/03/2007 99823
so on and so forth

I need to get an average of how many numbers were closed within 1 day, how
many were closed within 2 days, etc.

In this instance, I would say 5 total numbers, 4 closed within 1 day, 1
closed within 2 days

Hopefully this is possible... I have a sheet with a months worth of numbers.

Thanks again everyone.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200707/1

The only thing I can figure is that column B is how many "seconds" it took to
close out that particular line item....if so,
This for one day
=COUNTIF(B:B,"<=86400")
This for Two days
=COUNTIF(B:B,"<=172800")-COUNTIF(B:B,"<=86400")
This for Three days
=COUNTIF(B:B,"<=259200")-COUNTIF(B:B,"<=172800")
etc, etc............

hth
Vaya con Dios,
Chuck, CABGx3



"instereo911 via OfficeKB.com" wrote:

Good morning,

I have a workbook and my goal is to see when a number is no longer on the
sheet.

My workbook looks like this

A B
1 05/01/2007 25235
2 05/01/2007 68325
3 05/01/2007 78932
4 05/02/2007 68325
5 05/02/2007 11123
6 05/03/2007 99823
so on and so forth

I need to get an average of how many numbers were closed within 1 day, how
many were closed within 2 days, etc.

In this instance, I would say 5 total numbers, 4 closed within 1 day, 1
closed within 2 days

Hopefully this is possible... I have a sheet with a months worth of numbers.

Thanks again everyone.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200707/1

Hello,

You will need an auxiliary column next to B:B. In C1:

=COUNTIF($B$1:$B$6,B1)

In further cells you can enter the numbers 1, 2, 3, ... say in cells
F1:F3. Then in G3:

=COUNTIF($C$1:$C$6,F1)/F1

This will show how many numbers are finished in 1, 2, 3 etc days.

HTH
Kostis Vezerides

On Jul 12, 8:14 pm, "instereo911 via OfficeKB.com" <u27979@uwe wrote:
Good morning,

I have a workbook and my goal is to see when a number is no longer on the
sheet.

My workbook looks like this

A B
1 05/01/2007 25235
2 05/01/2007 68325
3 05/01/2007 78932
4 05/02/2007 68325
5 05/02/2007 11123
6 05/03/2007 99823
so on and so forth

I need to get an average of how many numbers were closed within 1 day, how
many were closed within 2 days, etc.

In this instance, I would say 5 total numbers, 4 closed within 1 day, 1
closed within 2 days

Hopefully this is possible... I have a sheet with a months worth of numbers.

Thanks again everyone.

--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200707/1