Forum Discussion
Solved
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($...
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
Your long formula results from your (bad) data structure (possibly a crosstab; blank rows).
Restructure your data into a dataset list and you can use simpler formulas and pivot tables.