Another variation to try
Place in C1:
=IF(A1="","",TEXT(SUMIF(A:A,A1,B:B),"#,##0")&" bbls "&A1)
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Starvoyager" wrote:
Thanks but the product name in cell A1 is not showing up just the amt of
barrels.

In other words if cell A1 contains "fresh water" then I want the totals row
to say "00 bbls fresh water". If I have 5 cells in row A that say "fresh
water" then I want all the bbls added that have "fresh water" in the cell
next to it. So all the bbls of fresh water are totaled in one cell. and for
what ever I change the product name to. Am I doing something wrong or am I
asking too much?

thanks again

Greg