Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: =COUNT issues

  1. #1
    New Member
    Join Date
    Jul 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default =COUNT issues

    Hello!

    I am currently trying to add up how many incidents are created monthly. The incident is in column A. There are also dates in column A. I only want to add up how many incidents there were. I have tried many different ways and cannot get it to work!

    I thought I would be able to figure this out, but I have been defeated. I have tried stating if A8<>"", since that is the first cell that must contain an incident number. But that did not work, I tried COUNTIF, COUNTIFS, and still nothing. I tried figuring out to state if it is not a date, count it, but no luck with that either.

    Please help!

    THANKS!!!

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,167
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: =COUNT issues

    Can you post a SMALL sample of data, with what you want to achieve
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,167
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: =COUNT issues

    Maybe try this.....depending on your data format
    Adjust the ranges to suit
    Code:
    =COUNTA(A1:A100)-COUNT(A1:A100)
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  4. #4
    New Member
    Join Date
    Jul 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: =COUNT issues

    Hello,

    Thanks for responding. I tried what you suggested and it did not work either. What other information from me do you need? I tried copying and pasting a small screen shot on a previous thread and that did not work.

    Hopefully this helps:

    I only want to count how many incidents there are, excluding the dates.
    I want the formula in B:1

    a b
    1 Total:
    2
    3 7/19/2014
    4 INC - these cells will be blank until a number is entered
    5 INC
    6 7/20/2014
    7 INC
    8 INC
    9 INC

    Does that clarify a little?

    Thanks again!

  5. #5
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,167
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: =COUNT issues

    OK, maybe this.....but it appears that your data is ALL formateed as text.
    If this is the case how will Excel know what is text and what is a date ???

    Excel 2003
    AB
    1Total:5
    2
    325/12/1952
    4INC - these cells will be blank until a number is entered
    5INC
    61/04/2014
    7INC
    8INC
    9INC

    Sheet1



    Worksheet Formulas
    CellFormula
    B1=SUMPRODUCT(--(ISTEXT(A2:A9)))

    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,057
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: =COUNT issues

    Also:

    =COUNTIF(A2:A9,"?*")

    which would be a tad faster.
    Assuming too much and qualifying too much are two faces of the same problem.

  7. #7
    Board Regular asusetyo's Avatar
    Join Date
    Feb 2014
    Location
    Indonesia, Jakarta
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: =COUNT issues

    Quote Originally Posted by Aladin Akyurek View Post
    Also:

    =COUNTIF(A2:A9,"?*")

    which would be a tad faster.
    Hi Aladin,

    I know about "*", but what does "?*" tell about?

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,057
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: =COUNT issues

    Quote Originally Posted by asusetyo View Post
    Hi Aladin,

    I know about "*", but what does "?*" tell about?
    ? stands for 1 char, * stands for 0 or more chars. Numbers are of course excluded.

    So, ?* stands for text of with length 1 or longer.
    Assuming too much and qualifying too much are two faces of the same problem.

  9. #9
    Board Regular asusetyo's Avatar
    Join Date
    Feb 2014
    Location
    Indonesia, Jakarta
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: =COUNT issues

    Quote Originally Posted by Aladin Akyurek View Post
    ? stands for 1 char, * stands for 0 or more chars. Numbers are of course excluded.

    So, ?* stands for text of with length 1 or longer.
    if by using "*" itself can exclude the number why put "?" in the formula? *cause all we want is just to exclude the date
    is there any symbols that can be put as criteria?

    Thanks,

  10. #10
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,057
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: =COUNT issues

    Quote Originally Posted by asusetyo View Post
    if by using "*" itself can exclude the number why put "?" in the formula? *cause all we want is just to exclude the date
    is there any symbols that can be put as criteria?

    Thanks,
    * means 0 or more chars. Do you want to count in the blank cells?
    Assuming too much and qualifying too much are two faces of the same problem.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •