# why dont this countif work

#### JASONW10

##### Board Regular
ok first i have a list of names in one cell and names in another cell right beside them then in another cell right beside them i have this equastion
=a1 &""& b1 this is to put the to names together like this
A.................B..............C
lm123........90544.......lm12390544

ok now on another page someone would type in one name in one cell then anohter name in another cell and they can put a tatol beside the 2nd name, now in a hidden cell the same formalu is there =a1 &""& b1 this is to give me the too names together just like on the fist page, another hidden cell beside this one is my countif statement =countif(d1,"sheet2!c2:c100",), if this works it should put a 1 in this cell but it dont work need some help

A...............B............C........................D..............E
lm123......90544.......15..............lm12390544......1

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
The range comes first in the Countif function. So rearrange it.

Also, why =A1&""&b1, you can use =A1&B1

JASONW10 said:
ok first i have a list of names in one cell and names in another cell right beside them then in another cell right beside them i have this equastion
=a1 &""& b1 this is to put the to names together like this
A.................B..............C
lm123........90544.......lm12390544

ok now on another page someone would type in one name in one cell then anohter name in another cell and they can put a tatol beside the 2nd name, now in a hidden cell the same formalu is there =a1 &""& b1 this is to give me the too names together just like on the fist page, another hidden cell beside this one is my countif statement =countif(d1,"sheet2!c2:c100",), if this works it should put a 1 in this cell but it dont work need some help

A...............B............C........................D..............E
lm123......90544.......15..............lm12390544......1

Invoke:

=A1&"#"&B1

=A1&""&B1

The CountIf formula then becomes:

=COUNTIF(Sheet2!\$C\$2:\$C\$100,X2&"#"Y2)

where X2 and Y2 house the user entries.

ok thxs ill give both a try when i go back to work someday ill have to break down and buy a copy of excel for home lol thxs

Replies
1
Views
154
Replies
5
Views
259
Replies
5
Views
225
Replies
0
Views
561
Replies
1
Views
419

1,196,250
Messages
6,014,244
Members
441,808
Latest member
xplainer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back