V lookup in separate TABS!

B

Bob Phillips

=COUNTIF(Sheet2!A:A,B10)

as an example

--
HTH

Bob Phillips

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

Iris21

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIF 11
How can I count number of sheets present in a workbook? 0
HOW DO I SET UP A SMALL BUSINESS USING EXCEL? 1
Remove Numeric from a Text String - Help? 9
Case Sensitive v-lookup needed 3
Run Lookup only once - Macro 0
how to show the date a spreadsheet was modified in a cell 0
V Lookup & IF Function 1

Top