Help with IF or VLOOKUP (I'm not sure which formula to use)

[deemac]

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.

 

[Max]

Try: =COUNTIF(D434,">=96")*807

 

[Dave Curtis]

Hi,

This should work for you.

=807*COUNTIF(D434,">96")

You can then apply a custom number format to the cell for the $ sign if you
want.

Dave

url:http://www.ureader.com/msg/104234550.aspx