I'm trying to find the easiest way to calculate the total amount of times a certain text in a specified range over 8 different pages in a single excel workbook. Right now I'm currently using a countif formula for each page and adding them together, but it's a long formula. Is there a more efficient way to do this?
The workbook in question is attached below. Please refer to the page title "Seed Stats" cell B4, which uses the countif formula over the pages #1 vs #16, #2 vs #15, etc.
Thank you!
Create a list of your tabs say in Column C of your Seed Stats
then use
Formula:
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
i used the indirect option before and it created a lag problem. Thank you though!, I'll just stick with what i have for now. Thank you for taking the time to answer!
yup. that's volatile
you can try to look at this one.
Formula:Please Login or Register to view this content.
or
search for Countif.3D
then compare it to your exisitng calculation.
hope it helps.
regards,
vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks