CountIF Question

[Guest]

I have the following equation in one of my excel sheets to calculate a percentage
=COUNTIF(L4:L25,"OnTime")/COUNTIF(L4:L25,"*"
The "L" row contains an IF statement that gives a certain status of certain shipments according to dates found in other cells
Everytime I add information this, I have to go to the equation above and change the "L25" cell to whatever the last cell number is. I would like to figure out how make this equation automatically find the end of the data and insert this cell number into the equation
Any ideas would be appreciated

Thanks

 

[Earl Kiosterud]

Korky,

One way is to "run it off the end:"

=COUNTIF(L4:L65536,"OnTime")/COUNTIF(L4:L65536,"*")

=COUNTIF(L4:L65536,"OnTime")/COUNTA(L4:L65536)

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have the following equation in one of my excel sheets to calculate a percentage:
=COUNTIF(L4:L25,"OnTime")/COUNTIF(L4:L25,"*")
The "L" row contains an IF statement that gives a certain status of

certain shipments according to dates found in other cells.

Everytime I add information this, I have to go to the equation above and

change the "L25" cell to whatever the last cell number is. I would like to
figure out how make this equation automatically find the end of the data and
insert this cell number into the equation.

 

[Guest]

Earl
Thanks for the response. I gave this a try, but unfortunately it did not work
Any other ideas

Thanks.

 

[Dave Peterson]

What happened when you tried it?

Earl,
Thanks for the response. I gave this a try, but unfortunately it did not work,
Any other ideas?

Thanks.