| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIf - More then 1 criteria - Please assist
Hi,
How can i use sumif formula with more then ONE criteria? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
=sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22)
-- Don Guillett SalesAid Software "Nir" wrote in message ... Hi, How can i use sumif formula with more then ONE criteria? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
Use SUMPRODUCT instead.
-- Brevity is the soul of wit. "Nir" wrote: Hi, How can i use sumif formula with more then ONE criteria? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
Nope. You want sumproduct to do that. Check out this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "Nir" wrote: Hi, How can i use sumif formula with more then ONE criteria? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
=SUM(SUMIF(A1:A10,{"x","y"},B1:B10))
Biff "Nir" wrote in message ... Hi, How can i use sumif formula with more then ONE criteria? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
apperantly this does not work when the arrays include error formulas values.
can you advise "Don Guillett" wrote: =sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22) -- Don Guillett SalesAid Software "Nir" wrote in message ... Hi, How can i use sumif formula with more then ONE criteria? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
Fix the formulas so that instead of returning errors they return some other
value like a zero or a blank "". Biff "Nir" wrote in message ... apperantly this does not work when the arrays include error formulas values. can you advise "Don Guillett" wrote: =sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22) -- Don Guillett SalesAid Software "Nir" wrote in message ... Hi, How can i use sumif formula with more then ONE criteria? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
i did so thanks
isnt there a way around? "Biff" wrote: Fix the formulas so that instead of returning errors they return some other value like a zero or a blank "". Biff "Nir" wrote in message ... apperantly this does not work when the arrays include error formulas values. can you advise "Don Guillett" wrote: =sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22) -- Don Guillett SalesAid Software "Nir" wrote in message ... Hi, How can i use sumif formula with more then ONE criteria? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SumIf - More then 1 criteria - Please assist
isnt there a way around?
Maybe. But you're better off correcting problems at their source rather than trying to accommodate those errors downstream. They end up making things more complicated! Biff "Nir" wrote in message ... i did so thanks isnt there a way around? "Biff" wrote: Fix the formulas so that instead of returning errors they return some other value like a zero or a blank "". Biff "Nir" wrote in message ... apperantly this does not work when the arrays include error formulas values. can you advise "Don Guillett" wrote: =sumproduct(--(a2:a22="joe"),--(b2:b22=1),c2:c22) -- Don Guillett SalesAid Software "Nir" wrote in message ... Hi, How can i use sumif formula with more then ONE criteria? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| Multiple SUMIF Criteria | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| "criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
| Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions | |||
Linear Mode
