Applying Formula to different range of cells after Filter is applied

Hello,

1. Sheet contains multiple customer names.
2. Need to sum the total for the cells highlighted in yellow.
3. In Feb column I'll use vlookup formula to get the quantity from my monthly extracted report.
4. I'll select the yellow highlighted cells applying filter.
5. Same range of the formulas should get copied to the Feb column.

If we look into the sum formula in C column i.e. Jan Quantity column, different range is been applied for all the customers.

In C3 cell - formula range is =SUM(C4:C6)
In C14 cell - formula range is =SUM(C15:C19)
In C25 cell - formula range is =SUM(C26:C33)

I believe we can use the Ctrl+R to drag the formula from one column to the very next column. Where all the specified range of cells gets copied to the next column.

I would like to use a different approach using a formula where we can copy same range of formulas from the previous month.

I had a little issue following exactly what you are asking for but i think it comes down to you needing a formula to sum all the quantities for each customer? If this is the case and the customer names that you want summed together are the same then i suggest using a sumif() formula. =SUMIF(B:B,"Customer Name",C:C)