=If - how to tell it to calc certain %'s only

C

Crazymom999

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
 
B

Bob Phillips

=SUMPRODUCT(--(A1:A3>=11%),--(A1:A3<=12%),B1:B3)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top