additional note: Please keep in mind that a dollar amount in column B may
fall between a floor and ceiling in columns C & D on a different row. For
example:

A B C D
10 $75 0 499
5 300 500 999
1 3500 1000 1499
15 1200 1500 1999
etc.

I would like a formula that sums all the rows in Column A where the dollar
amount falls between 0 and 499 (the answer would be 15). I will then have
another cell that asks for the sum of all the numbers in column A where the
dollar amount falls between 500 and 999 (the answer would be 0). I will have
9 cells with formulas that correspond to the nine levels of floors and
ceilings.
Thanks

"Tim Nealon" wrote:

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