Forum Discussion
CaRo110
Sep 27, 2024Copper Contributor
trying to simplify a formula
Hello All, I have this formula that I worked on. =COUNTIF($C$3:$I$3,CONCATENATE(R2,"*"))*$B$3+COUNTIF($C$5:$I$5,CONCATENATE(R2,"*"))*$B$5+COUNTIF($C$7:$I$7,CONCATENATE(R2,"*"))*$B$7+COUNTIF($...
- Sep 30, 2024
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
CaRo110
Sep 30, 2024Copper Contributor
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.
SergeiBaklan
Sep 30, 2024MVP
- CaRo110Sep 30, 2024Copper Contributor
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.
- SergeiBaklanSep 30, 2024MVP
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
- CaRo110Sep 30, 2024Copper Contributorunderstood.
Thank you all for all your help. Your help has been greatly appreciated