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

After re-reading this, I also want to make clear that I want to have a
total of all of the rows that have CASSVILLE in them.



wrote:
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

=sumproduct(--(D5:D100="CASSVILLE"), --(E5:E100))

for further reference check out...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson


" wrote:

After re-reading this, I also want to make clear that I want to have a
total of all of the rows that have CASSVILLE in them.



wrote:
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

Thanks for your help, this fixed my problem.

With the total for each case (plant) select the cell where you want to
have te result and use the SUM.IF formula, just follow the
instructions.
And for having the total rows for each case use COUNT.IF
If the number of rows is getting larger is it good to setup the
formulas with much larger ranges.
I hope this help you out.

Carlos

Sorry if a had any spelling problem. English is not my natal language.


--
CarlosAndres
------------------------------------------------------------------------
CarlosAndres's Profile: http://www.excelforum.com/member.php...o&userid=34169
View this thread: http://www.excelforum.com/showthread...hreadid=539340