Dear All,

I have a worksheet that contains sales data by months like this:

JUL AUG
YTD
Cust. Name - Sales - COS - GP Sales - COS - GP Sales - COS - GP

I want to sort YTD category by GP column but it seems its not working
categories JUL AUG & YTD are merge cells for each 3 columns under them, I
also try with normal cells for each category but not found correct results,
one more thing I would like to share that sales - COS - & GP amount are
retrieved via sumproduct formula where cust. Name & Month are conditions,

please help me out :)