B
bridgeb3
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(D5100="CASSVILLE",E5:E100) but this is
just giving me =REF.
Please help me out on what formula I should be using.
Thanks,
Barry Bridges
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(D5100="CASSVILLE",E5:E100) but this is
just giving me =REF.
Please help me out on what formula I should be using.
Thanks,
Barry Bridges