Forum Discussion
trying to simplify a formula
Formula works if we have 1 in all cells in column B
Have no idea if they need for something else. If not, we could do bit other way. If to keep, don't merge cells - that's always bad idea - use Center across selection starting from C
Please check in attached
Created a mock-up of what your real schedule may look like and applied your working formula in S2. Then, I used this one in T2:
=SUM(MMULT(TRANSPOSE(B3:B39),--(C3:I39=R2&"*")))It arrived at the same result. Now, I can't tell if this will work for you, but check out the attached file. If this is not what you want, please share your file (a link that gives full access to it on Onedrive or similar).
Here is a sample of what i am doing.
Your formula doesn't seem to work with it or I might be doing something wrong.
thank you. does it work around merged cells? I tried what you gave and it worked, then I added some more information and merged cells and it doesn't work now.
see attached file.
Formula works if we have 1 in all cells in column B
Have no idea if they need for something else. If not, we could do bit other way. If to keep, don't merge cells - that's always bad idea - use Center across selection starting from C
Please check in attached
