countif and vlookup

  • Thread starter Thread starter RichardO
  • Start date Start date
R

RichardO

Hello all,

I want to count the number of times items in column A are in a rang
called "Check". I have the following formula, but the formula i
assuming the item showes up once. Can anyone figure how to do this?

=IF(ISNA(VLOOKUP($A2,Check,1,0)=$A2),"",1)

Thank you.


RichardO
 
Richard,

How about

=IF(COUNTIF(Check,$A2)>0,COUNTIF(Check,$A2),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Richard,
I may be missing something but if I need to know how many times the value
shown in A2 appears in the range Check then I use = COUNTIF(Check,A2)
Best wishes
Bernard
 
Back
Top