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

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.

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

Try: =COUNTIF(D4:D34,"=96")*807
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"deemac" wrote:
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.

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

Hi,

This should work for you.

=807*COUNTIF(D4:D34,"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