In column A, I have each day of August in a separate row.
In column B, I have # of trans processed each day.
In column C, I need to asses a per trans fee of .45 if there are more than 100 trans for the month.

Without having to add an additional column to accumulate the number of trans for the month, is there a combination IF / SUMIF formula that i can give it to only assses the per trans fee if the monthly accumulation goes over 100? also -- on the specific row that it happens on, I only want to charge for the # of trans over 100, not necessarily the # of trans for that day.

Any help would be appreciated !!