I’m wondering if you could help or perhaps suggest a resolution to my current issue
I have a live ‘cube’ of data against which I have some target statistics set up.
Some of these statistics are derived from a calculation, per row (these are individual entries in the database), that looks at specific cells and if they are ‘completed’ or filled with data.
What I’m having problems with is creating a formula in Column BE (VBA?) that will look at each row and look at specific cells and if these cells are filled, then add 1 to the calculation up to a maximum of 23.
I have attached an extract from the actual sheet. The yellow highlighted columns are the columns that I wish to look at for conformity ie. the cells on each row within those columns are completed. All other columns I need disregarded as part of the calculation.
Ive put in a sample calculation in Column BE for the last two row entries just to show what the result Im trying to accomplish, with the cells on the last two row highlighted in green to show the missing data that would culminate in the resulting sum being displayed.
Ive tried various combinations of INDEX and MATCHING with LOOKUPS and setting criteria to match. I have not yet been able to succeed in achieving the desired result as I cannot seem to lock out the columns I do not need and just look at the yellow highlighted cell entries per column per row.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.