Abid

I'm not sure how to ties all 3 of these into one neat package, but you
could use helper cell hidden off-screen somewhere and have E15 point to
the cell the shows the sum of the following:


BETWEEN 33 & 34 "=IF(AND(E$12<35,E$1232),3,0)"
BETWEEN 35 & 40 "=IF(AND(E$12<41,E$1234),4,0)"
BETWEEN 41 & 42 "=IF(AND(E$12<43,E$1240),3,0)"

Now lets assume your helper cells are Z1 to Z4

Z1 = "=IF(AND(E$12<35,E$1232),3,0)"
Z2 = "=IF(AND(E$12<41,E$1234),4,0)"
Z3 = "=IF(AND(E$12<43,E$1240),3,0)"
Z4 = "=SUM(Z1:Z3)

E15 = "=Z4"

Don't forget to remove the quote wrapping from the formula's.

This works well if you want to go down the track of using the helper
cell scenario, else hang on until someone else comes up with another
shorter, more direct idea.

Cheers

HTH
Mick.