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

    Oct 15, 2006, 11:59 AM
    Another Count Question
    I have a Spread sheet which links to my Database. This sheet querys the database and puts everything in a what we call a "TAM" number order. (example D1158 , D1159 , D1125). All of these numbers are shown in Column A. Is there a way I can set a cell to count the number of D1158's there are? I have tried the count formula, but I think I am missing a step.

    Thanks :confused:
    mccloudm's Avatar
    mccloudm Posts: 7, Reputation: 1
    New Member
    		  
    #2

    Oct 15, 2006, 12:28 PM
    Found it:

    =Countif(A:A,"D1158")

    Just goes to show, you just got to keep looking. :D

    thanks!
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 question [ 2 Answers ]

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

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

View more questions Search