Looks good. I'm assuming that "mush" is the specific value in the B column,
aye?

"Teethless mama" wrote in message
...
Shorter version

=SUMPRODUCT((B2:B300="mush")*(H2:H300-J2:J300))


"Jim Cone" wrote:


"that's cool"? - Did you actually try the formula?

Insert a minus sign at the end of the formula and repeat using
the correct columns (this time) ...
=SUMIF(B2:B300,"=mush",H2:H300) - SUMIF(B2:B300,"=mush",J2:J300)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins available)



"DB" wrote in message
OK, that's cool. Now what about the J column part?
How do I put it all together?


"Jim Cone"
wrote in message
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