=COUNTIF(

then with the cursor after the first parenthesis select the range on the
other sheet with your mouse


--
Regards,

Peo Sjoblom


"Mighty Magpie" <mighty.magpie@home wrote in message
...
Hello



If I use the following formula I sort of get what I want but I would like
to put the formula onto a sheet named "LIST" and for it to find the
information from a different sheet (named DATA)



=COUNTIF(E2:E50000,I2)





Can someone please advise me how to do this?



TIA