LinkBack URL
About LinkBacks
Hello!
First, I'd like to thank everyone on this forum. Although this is my first post, I've been able to learn so much from others' threads and questions! I hope I've put this question in the most convenient possible format, but please let me know if anything would be more helpful (e.g., including more information, embedding a table). I've attached a test spreadsheet with a sample of what I'm hoping to do, including what my formula shows and what the formula should show. Please let me know if the attachment didn't go through!!
My issue is around combining several countifs functions. In the attached example, I have 3 stores that need to go through a series of activities, each of which has 3 steps, in order to get ready for a program launch. (Note: Eventually, these steps will be completed in order, but as my full file has thousands of stores, I used dummy data which is a little inconsistent. For instance, some stores may have Step 1 incomplete but Step 2 complete. This will not be possible during the actual launch.)
I want my countifs function to count how many stores are at each individual step. This, at first seems to be a simple countifs function, counting the number of stores matching the correct activity, step, and with a status of "incomplete". I'm running into an issue, however, around making sure that "incompletes" aren't double counted. For instance, if a store's step 2 and step 3 are incomplete, the store should be designated at step 2, but my countifs function is counting the store as a step 2 and a step 3 store. I've tried subtracting countifs functions and sumproduct functions, but nothing seems to work and I'm completely stuck.
Please let me know if you'd like for me to put more of the formulas in the actual post. From reading other threads, it sounds like folks prefer attachments, but I can also include more detail here if it's helpful.
Thank you!!!!
Test.xlsx
Register To Reply
Bookmarks