CPP/QPP - Employee cumulative contributions.

I'm currently doing a Canadian payroll analysis on CPP/QPP employee contributions but my formulas require to be a bit more dynamic.

How can I replicate column "O" in column "F" and have a cumulative total in column "G"?

Appreciate your guidance...thanks.

Perhaps you mean:

replicate column "D" in column "F"

So you want to copy the values in column D to column F
and then just have the cumulatives in G but leaving the blanks as they are???

Hi @jantonio

Sometimes it's a pain in ***** to try to upload a file
I can't get it done

please follow this:

Request:

I'm currently doing a Canadian payroll analysis on CPP/QPP employee contributions but my formulas require to be a bit more dynamic.
How can I replicate column "D" in column "F" and have a cumulative total in column "G"?

Solution:
To replicate column E in Column F:
in cell F2: Formula =E2 ; and copy down full column

To do cumulative sum in column G, leaving blanks:
in cell G3: Formula =IF(F3=0,"",SUM($F$3:F3))
and copy down full column

Finally, here is the file

you are welcome