I have 4 columns
Column A contains a whole number
Column B contains a dollar amount
Colum C contains a dollar amount I refer to as a floor
Column D contains a dollar amount I refer to as a ceiling
Columns A & B have 10 rows
Columns C & D have 9 rows

I would like to sum the rows in Column A if the dollar amount in column B
falls between the floor and ceiling in columns C & D. I plan to copy this
formula to other areas of the worksheet that contain 9 rows that correspond
to the various floors and ceilings.

Does this make sense? I keep trying the sumif formula, but it doesn't seem
to be working for me.
Thanks