Forum Discussion
Question on Sumifs
Hello: Please can someone help me understand why formula is not able to work when it works in the first cell in K2 and K4? However, it doesnt seem to work for the rest of the rows up to row 10. Th...
The merged cells is somewhat necessary.
"Somewhat" Necessary <> Necessary
Use some other method--e.g., background colors--to achieve the same desired objective with regard to the display.
Merged cells, in general, especially in an area used in computation of results, are a recipe for disaster, as you are discovering.
