How to do sum calculation for filtered cell only by using offset function

[Meiyin]

Refer to column I, I need to do the manual formula to get the Accumulated Sale% once i filter Column F. So, is there any automated formula can be applied in Column I once i do the filtering?

 

[NARAYANK991]

Hi ,

See if this is correct.

Narayan

 

[Meiyin]

It's really helpful. Thank you.