why dont this countif work

[JASONW10]

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

 

[NBVC]

The range comes first in the Countif function. So rearrange it.

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

 

[Aladin Akyurek]

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

in constructing the additional column

instead of:

=A1&""&B1

The CountIf formula then becomes:

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

where X2 and Y2 house the user entries.

 

[JASONW10]

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