Hi

I am not sure if this is possible, but I have a table containing a row of
values (D4 to D34). At the bottom of the row (D35) I want to create a
formula to multiply the amount of cells that are 96 or greater by $807.

So, say there are 15 cells in the section D4 to D34 that contain a value of
96 or more, I want D35 to contain a formula that returns the sum 15*807=12105.

Any help would be greatly appreciated. Thanks.