V lookup in separate TABS!
=COUNTIF(Sheet2!A:A,B10)
as an example -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Iris21" wrote in message ... 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! |
V lookup in separate TABS!
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! |
All times are GMT +1. The time now is 08:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com