In Excel 2010, how do I to use countif for a number of tabs listed on the first sheet of a spreadsheet?
In the attached spreadsheet, I have a list of 42 tabs.
I want to create a formula in column b that will tell me how many non-blank rows there are in each of the tabs
from row a5 to the end of the spreadsheet. I have been using 1000 as the highest number, but I know there
are a lot fewer than that on the largest tab.
MS2003-to-2007.xlsx
I want to create a formula in column b that will tell me how many non-blank rows there are in each of the tabs
from row a5 to the end of the spreadsheet. I have been using 1000 as the highest number, but I know there
are a lot fewer than that on the largest tab.
MS2003-to-2007.xlsx
if you want to use CountIF function, you can try this instead.
=1000-5-COUNTIF(INDIRECT("'"&A2&"'!A5:A1000"),"<>")ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Worked great, thanks!
Open in new window
and drag down the formula.you can customize the formula accordingly.
MS2003-to-2007_b.xlsx