Ask Experts Questions for FREE Help !
Ask
    grumpy2001's Avatar
    grumpy2001 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 12, 2006, 10:00 AM
    Count question
    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?
    Depressed in MO's Avatar
    Depressed in MO Posts: 571, Reputation: 94
    Senior Member
    		  
    #2

    Oct 12, 2006, 10:20 AM
    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.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Oct 12, 2006, 11:04 AM
    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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel count function [ 12 Answers ]

I am trying to count a large group of cells that are colored depending on the data. For example: I want to count the number of red cells which are faults. I tried the countif but not sure how to set the criteria. Thanks for any help.

Does Sincerity Count? [ 20 Answers ]

I have often heard some Christians say that sincerity doesn't count if it is based on innacurate knowledge and that such ignorance can lead to ultimate destruction at the hands of God. I disagree with this concept. Do you? They cite the following scripture to support their conclusion. Romans...

Count in the Report [ 5 Answers ]

Dear... I have aquestion about the report . I give you example . Table: Size Date FCL 1 X 40' 2/6/2006 FCL 2 X 40' 5/6/2006 FCL 3 X 40' 9/6/2006

Count my web page [ 3 Answers ]

Please, tell me on what site I should register my web page in order to obtain information about how many people visited my web, from what country they accessed my web page. The latter is necessary. Thanks.

View more questions Search