Question re COUNTIF function - reading data from a differnet sheet

M

Mighty Magpie

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
 
P

Peo Sjoblom

=COUNTIF(

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

bpeltzer

Assuming the criterion in I2 is still on the LIST worksheet along with the
formula,
=COUNTIF(DATA!E2:E50000,I2)
 
Top