I need a function guys!

[DB]

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

 

[Jim Cone]

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



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

 

[DB]

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

 

[Jim Cone]

"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)



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

 

[DB]

This is my first attempt at Excel formulas, OK?

"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)



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

 

[Guest]

Shorter version

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

 

[DB]

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