Thanks:  0
Likes:  0

# Thread: =COUNT issues

1. ## =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.

THANKS!!!

2. ## Re: =COUNT issues

Can you post a SMALL sample of data, with what you want to achieve

3. ## Re: =COUNT issues

Maybe try this.....depending on your data format
Adjust the ranges to suit
Code:
`=COUNTA(A1:A100)-COUNT(A1:A100)`

4. ## 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. ## 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)))

6. ## Re: =COUNT issues

Also:

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

which would be a tad faster.

7. ## Re: =COUNT issues

Originally Posted by Aladin Akyurek
Also:

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

which would be a tad faster.

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

8. ## Re: =COUNT issues

Originally Posted by asusetyo

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.

9. ## Re: =COUNT issues

Originally Posted by Aladin Akyurek
? 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. ## Re: =COUNT issues

Originally Posted by asusetyo
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?

## User Tag List

#### Posting Permissions

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