Forum Discussion
COUNTIF function
I am using the countif function to add cells with a given value. It is working great. EXCEPT, if that value occupies a cell that has been merged, I need it to recognize the value in BOTH cells. It...
Hi Marti,
First and main advise don't use merged cells. Never. Playing with not-merged cells formatting you practically always may have the same formatting effect as with merged cells.
If calculate on merged cells that could be a workaround but the formula will be in times more complex and it very depends on how is your data structured.