ABC Analysis based on multiple columns

[divyakolavil]

Hi all,

I have to categorize Articles based on  YTD Sales Data on the column combination of  Div-Cat-Gender-Site code.The articles which contributes to the 70% of sales will be calssified as A, 70% to 90% as B, and 90% above as C. Below   sample screenshot FYR.. 

 I have tried in excel as per this, not sure if it is 100%. Also attaching the excel file 

https://we.tl/t-lzSbx44bEv