Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested sumif?
trying to sum one column (G:G) that contains weight by lbs if two criteria
are met - 1) if column (B:B) = "1-Grains" and 2) if col (H:H) = "lb" (because there are other units of weigt - ie fl oz, oz etc I'm only wanting to get the total weight for a specific category and all items in that category that are measured in lbs. Help - I'm reading online and only using MS Excel 2003 SUMIFS is not defined in 2003. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested sumif?
When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((B1:B100="1-Grains")*(H1:H100="lb"),G1:G100) If this post helps click Yes --------------- Jacob Skaria "Rachel" wrote: trying to sum one column (G:G) that contains weight by lbs if two criteria are met - 1) if column (B:B) = "1-Grains" and 2) if col (H:H) = "lb" (because there are other units of weigt - ie fl oz, oz etc I'm only wanting to get the total weight for a specific category and all items in that category that are measured in lbs. Help - I'm reading online and only using MS Excel 2003 SUMIFS is not defined in 2003. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested sumif?
=sumproduct((b2:b22="1-grains")*(h2:h22-"lb")*g2:g22)
do not use entire columns -- Don Guillett Microsoft MVP Excel SalesAid Software "Rachel" wrote in message ... trying to sum one column (G:G) that contains weight by lbs if two criteria are met - 1) if column (B:B) = "1-Grains" and 2) if col (H:H) = "lb" (because there are other units of weigt - ie fl oz, oz etc I'm only wanting to get the total weight for a specific category and all items in that category that are measured in lbs. Help - I'm reading online and only using MS Excel 2003 SUMIFS is not defined in 2003. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
nested sumif?
Thank you so much!!!
"Jacob Skaria" wrote: When you have multiple criteria use SUMPRODUCT() =SUMPRODUCT((B1:B100="1-Grains")*(H1:H100="lb"),G1:G100) If this post helps click Yes --------------- Jacob Skaria "Rachel" wrote: trying to sum one column (G:G) that contains weight by lbs if two criteria are met - 1) if column (B:B) = "1-Grains" and 2) if col (H:H) = "lb" (because there are other units of weigt - ie fl oz, oz etc I'm only wanting to get the total weight for a specific category and all items in that category that are measured in lbs. Help - I'm reading online and only using MS Excel 2003 SUMIFS is not defined in 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF with VLOOKUP nested | Excel Discussion (Misc queries) | |||
Nested IF / SUMIF statements | Excel Discussion (Misc queries) | |||
nested sumif | Excel Discussion (Misc queries) | |||
sumif and countif nested? | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions |