Well you got one, if you look in Excel help for the SumIf function...
=SUMIF(H2:H300,"=Mush",B2:B300)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
"DB" wrote in message
I need a function guys!
I need to sum the numbers in column H (H2:H300) but only those numbers in
the rows where a specific value exists in column B . I need to do the same
for column J with the same B value and then subtract the J total from H
total. Is this possible?
Thanks,
DB