Count merge cells formula (VBA) is not working

[shiva_raj]

HI



I wrote a code by using Sumifs function. in this code i find out starting column number (for each category box), ending column number by using #selection.columns.count# based on Merged cells in 2nd row & 11 row (first attachment). But this formula is not working properly. in the summary sheet (first attachment & sheet name: ks sales) few violet coloured cells were not getting result. please correct the code.

Regards
shiva