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

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

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

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

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Crazymom999" wrote in message
...
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