Help W/Small Formula

[Evagrius Ponticus]

Hi - This formula isn't working for me. If M3 has any of the values in range b3:b22 in another worksheet - then place a one in the cell w/the formula . . .I confirmed with cse . . .thanks for any help . .

=IF(M3=STATS!$B$3:$B$22,1,0)

 

[Diablo II]

will the word stats! be in M3 ? if so the word need to be like this,

=IF(M3="STATS!"$B$3:$B$22,1,0)

if not sorry.

 

[Evagrius Ponticus]

STATS is the name of the page . .

 

[Ragnar1211]

i beleive you need to do the following:

=sum(IF(M3=STATS!$B$3:$B$22,1,0))

confirmed with CSE.

 

[Colin Legg]

Here's one way:

=(COUNTIF(STATS!B3:B22,M3) > 0)+0

 

[Evagrius Ponticus]

yup! Thanks for the help fellas!!