CountIF Question

K

korky

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
 
E

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
-------------------------------------------

korky said:
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
Click to expand...
certain shipments according to dates found in other cells.
Everytime I add information this, I have to go to the equation above and
Click to expand...
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.
 
K

Korky

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

Thanks.
 
Top