| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF function with multiple results: No problem for you guys, but for me... | Excel Worksheet Functions | |||
| need help guys | Excel Worksheet Functions | |||
| First post, need help guys! | Charts and Charting in Excel | |||
| Please Help Guys! | Excel Worksheet Functions | |||
| Please Help Guys! | Excel Worksheet Functions | |||
![DB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
