Summing a Row with factors

[cage4000]

Hi All,

I am trying to make a formula that will sum a column in my report which is
called [# Of Pallets]. But before it sums the [# Of Pallets] it needs to
look at the same row at a field called [DockDoor] and only sum [# Of Pallets]
if [DockDoor] is between 1 and 200.

Is there a way to do this?

Please no VB answers.

Thanks,

Cage