Excel: Formula with multiple conditions that sums the column

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?

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of October 27, 2014.

For more resources for Microsoft Excel