Give this a try

=sumproduct((A1:A311.5%)*(A1:A3<12%)*B1:B3)


"Crazymom999" wrote:

Hi, Please help. I am trying to get Excel to calculate the following.
A1 = 11.8% A2 = 12.8% A3 = 11.67%
b1 = £20 b2 = £30 b3 = £18

Only to calculate any '£' between 11.5% -12.00% = £38.

Please help - hours later and my head is spinning! Thanks in advance,
Crazymom999