Formula with multiple conditions that sums the column

[Helliott99]

I have a column (G2:G168) with fee amounts in them. The fee is based annually, biannually or triennially - this designated in Column I2:I168. I want the to total of the fee column to show the "annual cost" of the fees. For example cell G2 might need to be divided by 2 or 3 depending on whether or not I2 said Bi or Tri in it before it was included in the sum. Is there a way to do this?

 

[Helliott99]

That looks ok. But what have you done with the SumProduct/SumIfs solution?

It is a total at the bottom of the fee column.