Editing a formula to accomodate new information

[bite_tony]

Hi, In my spreadsheet (attatched) the small table to the right creates a monthly total for incoming daily payments which are detailed in the main table on the left. (this is a different total to the weekly totals as the weekly totals do not allow for months which finish mid week).

I have just inserted a new column (C) I would like the figure in this column to contribute to the monthly total in G4.

I got some help from this someone on this forum to create the formula in G4 and now I cannot figure out how to change the formula in G4 (and downward for further months) to include the new payments now being detailed Column C.

I hope that makes sense, and i hope someone can help.