"Starvoyager" wrote:
.. I wanted to limit the range of cells for the tank
products and this works ...

=IF($D$2:$D$10="","",TEXT(SUMIF($A$2:$A$10,D2,$B$2 :$B$10),"#,##0")&" BBLS
"&D2)

The IF check on col D should actually be pointing to single cells,
viz. suggest you change it to this, and copy down:
=IF(D2="","",TEXT(SUMIF($A$2:$A$10,D2,$B$2:$B$10), "#,##0")&" BBLS "&D2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---