quick help

[ehsas]

=SUMPRODUCT((HPACB=1)*(HPNINS<24)*(RATE={4.50055})*BAL)

In above formula I am trying to give the rate range between 4.500 to 5.500 but it giving me zero outstanding where there is outstanding.I believe there is problem In range.Could any please help.Regards,

 

[Andrew Poulsom]

I'll ask again.

Which criteria do you want to change when you copy the formula down? Is it HPACB=1 or something else or more than one?

Or to put it another way what should the formula be if it is in the next row down?