I have a spreadsheet with the following columns:
Plant (D), Cases In (E), Cases Out (F)

I want to pick a column (plant) and for every row that has CASSVILLE in
it, I want to add the number of cases in

I thought I could use =SUM(IF(D5:D100="CASSVILLE",E5:E100) but this is
just giving me =REF.

Please help me out on what formula I should be using.

Thanks,
Barry Bridges