I have a spreadsheet that calculates the number of minutes late a truck is in departing compared to a target time. There are a number of trucks listed, each with a different target time. In column “D” each truck has a destination code of ether “Prov”, “HD” of “SC”. I want to be able to count the number of trucks that have a number of minutes late (calculated by a formula which I already have written) listed in column “J” that are only code “Prov”. Can anyone help me with the formula I need to write to accomplish this task?

Quote:

---

Originally Posted by grumpy2001

I have a spreadsheet that calculates the number of minutes late a truck is in departing compared to a target time. There are a number of trucks listed, each with a different target time. In column “D” each truck has a destination code of ether “Prov”, “HD” of “SC”. I want to be able to count the number of trucks that have a number of minutes late (calculated by a formula which I already have written) listed in column “J” that are only code “Prov”. Can anyone help me with the formula I need to write to accomplish this task?

---

Are you familiar with MS Access? I think this would be easiest to get your data in here.
You can create a query to get this information, then when you run the query, copy and paste your report into MS Excel.
Format at your leisure.
But you can plug in this criteria, including your calculations to get what you are looking for, if you know how to use MS Access.

What you need is to use the Microsft Query option under the Data menu. There is no one formula to do what you want. I suggest you lookup Queries in Excel help for details on how to use it.

I do agree, however, that what you are looking at would be better off done in Access than Excel. If you have Access and want some help setting this up, post in the Database forum.