software

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

Give this a try

=sumproduct((A1:A3gt;11.5%)*(A1:A3lt;12%)*B1:B3)quot;Crazymom999quot; wrote:

gt; Hi, Please help. I am trying to get Excel to calculate the following.
gt; A1 = 11.8% A2 = 12.8% A3 = 11.67%
gt; b1 = £20 b2 = £30 b3 = £18
gt;
gt; Only to calculate any '£' between 11.5% -12.00% = £38.
gt;
gt; Please help - hours later and my head is spinning! Thanks in advance,
gt; Crazymom999

=SUMPRODUCT(--(A1:A3gt;=11%),--(A1:A3lt;=12%),B1:B3)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Crazymom999quot; gt; wrote in message
...
gt; Hi, Please help. I am trying to get Excel to calculate the following.
gt; A1 = 11.8% A2 = 12.8% A3 = 11.67%
gt; b1 = �20 b2 = �30 b3 = �18
gt;
gt; Only to calculate any '�' between 11.5% -12.00% = �38.
gt;
gt; Please help - hours later and my head is spinning! Thanks in advance,
gt; Crazymom999