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

D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Sumif help.... 10
Formula for Dates and CF Colour then convert to Text 3
Find first cell in a row not equal to 3
Not sure which formula to use.. 4
Excel2000 A working formula has {braces} which disappear. Why? 3
Which function will shorten IF-THEN-ELSE ? 5
complex vlookup function - possible? help! 2
Combining If, Vlookup in formula 2

Top