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