Question re COUNTIF function - reading data from a differnet sheet

  • Thread starter Thread starter Mighty Magpie
  • Start date Start date
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
 
=COUNTIF(

then with the cursor after the first parenthesis select the range on the
other sheet with your mouse
 
Assuming the criterion in I2 is still on the LIST worksheet along with the
formula,
=COUNTIF(DATA!E2:E50000,I2)
 
Back
Top