Need help with tiered subjective formula

[JAMIEFRSMITH]

Hello,

I am trying to build a formula that will enter 0 if the sum of the range of cells selected doesn't agree with the requirements, and if the sum of selected cells does agree with the requirements then it will be multiplied by a certain number. This is for a tiered calculation where there will be 3 tiers of ranges and each cell with the formula written in it will have to calculate if the sum fits in its designated range or if it does not it will be equal to 0.

Here is what I have so far:

=IF(AND(C5:E7>=120,C5:E7<=149),+C5:E7*12,"0")

Now I have tried so many different formulas I can remember, its amazing how 10 years since I took a computer class can make me forget all the formulas I used to know by heart.

I am will to try any logical suggestions.

Thanks in advance.

 

[iyyi]

Try:
=IF(AND(SUM(C5:E7)>=120,SUM(C5:E7)<=149),SUM(C5:E7)*12,0)