Copy paste different formulas from a multiple selection on filtered rows

Question

I have a dataset where the columns calculate differently, the total lines are calculated in the same way for each column, but the formula for the Total can vary by row.

In the example below, I have sales which is calculated one way, recurring revenue which is calculated in another etc.

The total rows are the sum of the individual product rows above it, not including intercompany.

I know I can create a SUMIFS formula to do this, but instead I am wondering if there is a way to filter, then copy/paste the different formulas from the multiple selection Total rows to columns when the rows are filtered

Here you can see how the row formulas for Totals are not all the same:

I have attempted:

Filter

CTL+C

Home>Editing>FInd&Select>Special>Visible cells only

CTL+V

but I get this error and it doesn't paste the formulas

Is this possible for formulas with a multiple selection?

Answer 1

Could you share us a test file with some dummy data to test?

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.