Simplifying A Forumla

[Slycon]

I'm developing a spreadsheet for work, and I need to simplify the following formula:

=IF(AND(B4>0,B4<8),1*A4,0)+IF(AND(B5>0,B5<8),1*A5,0)

I need it to calculate from B4:B30 and A4:A30, and repeating the formula 27 times just doesn't seem all that efficient. (I currently have it calculated this way, and it does work, but needless to say it's extremely long.)

To further explain,here is what I'm trying to accomplish:

Column A equals the unit, which will either be 1 or .5 if it's a split sale. Column B equals the date on which the unit was sold. If the unit is sold within a specified date range (in this instance, the 1st through the 8th), it needs to be added to this cell.

[mikerickson]

Try this
=IF(AND(0<B4,B4<8),A4+A5,0)

[Slycon]

Try this
=IF(AND(0<B4,B4<8),A4+A5,0)

Thank you for the prompt response.

I need it to calculate Column B from B4 through B30 though.

[Paul]

Hi Slycon,

Does this formula help? (Place in any open cell outside of A4:A30 and B4:B30)

Please Login or Register  to view this content.

This will sum every cell in A4:A30 in which B4:B30 is in your range of >0 to <8.

[Slycon]

Hi Slycon,

Does this formula help? (Place in any open cell outside of A4:A30 and B4:B30)

Please Login or Register  to view this content.

This will sum every cell in A4:A30 in which B4:B30 is in your range of >0 to <8.

It works perfectly. Thank you very much!

[Paul]

You're welcome, glad I could help out.