|
I need a function guys!
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 |
I need a function guys!
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 |
I need a function guys!
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 |
I need a function guys!
"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 |
I need a function guys!
This is my first attempt at Excel formulas, OK?
"Jim Cone" wrote in message ... "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 |
I need a function guys!
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 |
I need a function guys!
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 |
| All times are GMT +1. The time now is 04:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com