Countif Query

[Icehockey44]

Hi All,

I need to count some data!!

The problem is the data looks like this:

A1
A2
A3
A4
ABC
RAA
RBB
RCC

i only want to count the entries whihc are A1 A2 A3 etc not the ABS.

currently I have entered count anything beginning with A ("A*"), but this is now incorrect!!

This will be part of an existing formula where I am also counting a sencondry and 3rd column to. So am not wanting these other counts to be disrupted!

Also where I am counting those that start with R ("R*") I now need to also count the ABC entries within this number.

Looking forward to your help

Donna

 

[Icehockey44]

i also need to add another count to this.

so if I use the formula that you suggested and added to it, would this work?

SUMPRODUCT(--(ISNUMBER(MID(A1:A8,2,1)+0)),--(B1:B8="ROUTE")),--(C1:C8="Under")

So by adding Over or Under to the data sheet.

Cheers

Donna

 

[VoG]

Yes, that will work.

 

[Icehockey44]

its not working!!!! do i need to add something as, as I have written it brings back0 (zero)!!

sorry with all the questions!!

Donna

 

[VoG]

It is working here. Do the cells in column C contain exactly Under?

Excel Workbook
	A	B	C	D
1	A1ab	ROUTE	Under	2
2	A2gh	STATIC	Over
3	A3jw	ROUTE	Under
4	A4mm	ROUTE	Over
5	ABC	STATIC	Over
6	CDE	ROUTE	Over
7	BGH	STATIC	Over
8	ETG	STATIC	Under
Sheet8

 

[Icehockey44]

VoG, thanks very much for your help yesterday. I have had another go this morning, and he presto it worked. i have now made an automated template incorporating your formulas.

Once again thankyou very much for your time and patience.

You are a star

cheers

Donna