=COUNT issues

[Traun2445]

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

 

[Michael M]

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

 

[Michael M]

Maybe try this.....depending on your data format
Adjust the ranges to suit

=COUNTA(A1:A100)-COUNT(A1:A100)

 

[Traun2445]

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

<tbody>
</tbody>

Does that clarify a little?

Thanks again!

 

[Michael M]

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
	A	B
1	Total:	5
2
3	25/12/1952
4	INC - these cells will be blank until a number is entered
5	INC
6	1/04/2014
7	INC
8	INC
9	INC
Sheet1

Cell Formulas
Range	Formula
B1	=SUMPRODUCT(--(ISTEXT(A2:A9)))

 

[Aladin Akyurek]

Also:

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

which would be a tad faster.

 

[asusetyo]

Also:

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

which would be a tad faster.

Hi Aladin,

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

 

[Aladin Akyurek]

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.

 

[asusetyo]

? 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,

 

[Aladin Akyurek]

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?