Count If
 

Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

Thanks Bob but that didn't seem to work

"Bob Phillips" wrote:

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

Care to elucidate, it worked in my test.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fiona" wrote in message
...
Thanks Bob but that didn't seem to work

"Bob Phillips" wrote:

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

In your original post you said
I've done th {} at each end but it doeasn't work.
If you actually did that, do this:
remove the {} and then hold down the ctrl + shift keys and touch the enter
keylet go.
Now you should see the {} and the formula should work.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fiona" wrote in message
...
Thanks Bob but that didn't seem to work

"Bob Phillips" wrote:

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

Sorry Bob, I've been looking at it again and the problem is that in my
previous formula I used the 'contains' feature ("*"&A10&"*") but with your
formula the match needs to be exact. I've tried to enter the 'contains' bit
but this does not give the correct result.

I want to count D5:D5000 if it contains A10.

Thanks again for your help

Fiona
:)

"Bob Phillips" wrote:

Care to elucidate, it worked in my test.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fiona" wrote in message
...
Thanks Bob but that didn't seem to work

"Bob Phillips" wrote:

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

I did read your post and that is why I used Find, so I cater for contains.

It might be a case problem, try changing FIND to SEARCH.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fiona" wrote in message
...
Sorry Bob, I've been looking at it again and the problem is that in my
previous formula I used the 'contains' feature ("*"&A10&"*") but with your
formula the match needs to be exact. I've tried to enter the 'contains'
bit
but this does not give the correct result.

I want to count D5:D5000 if it contains A10.

Thanks again for your help

Fiona
:)

"Bob Phillips" wrote:

Care to elucidate, it worked in my test.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Thanks Bob but that didn't seem to work

"Bob Phillips" wrote:

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H
in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona

Count If
 

Thankyou, that solved it.

"Bob Phillips" wrote:

I did read your post and that is why I used Find, so I cater for contains.

It might be a case problem, try changing FIND to SEARCH.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Fiona" wrote in message
...
Sorry Bob, I've been looking at it again and the problem is that in my
previous formula I used the 'contains' feature ("*"&A10&"*") but with your
formula the match needs to be exact. I've tried to enter the 'contains'
bit
but this does not give the correct result.

I want to count D5:D5000 if it contains A10.

Thanks again for your help

Fiona
:)

"Bob Phillips" wrote:

Care to elucidate, it worked in my test.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Thanks Bob but that didn't seem to work

"Bob Phillips" wrote:

Fiona,

Try this

=COUNT(IF(Page1!$J$5:$J$10000=$H$1,IF(ISNUMBER(FIN D(A10,Page1!$D$5:$D$5000)),1)))

still array entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Fiona" wrote in message
...
Hi
I'm trying to get the following formula to work:
COUNT(IF(Page1!$J$5:$J$10000,$H$1,IF(Page1!$D$5:$D $5000,"*"&A10&"*",0)))

But it isn't. I'm trying to count the cells on page 1 that have H
in
coloumn J, but also contain A10 in coloumn D.

I've done th {} at each end but it doeasn't work.

Any help would be very much appreciated.

Thanks
Fiona