V lookup in separate TABS!

  • Thread starter Thread starter Bob Phillips
  • Start date Start date
B

Bob Phillips

=COUNTIF(Sheet2!A:A,B10)

as an example

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
hi,

can anyone tell me how to count the number of times an item "i.e no, yes,
maybe" appears in a column, but the catch is how do I do it when they're on
separate sheets? The counted number is displayed in a different tab than the
values counted. Is it a v-lookup, but how do i control which tab to look in?

THANKS!
 
Back
Top