Home 
Search 
Today's Posts 
#1
Posted to microsoft.public.excel.misc




sumifs formula in excel 2007
Hello, within a sumifs formula, I am trying to include 2 variables withn one
of the conditons (i have several conditons, but all others just need to look for 1 condition in 1 colum)..i need to return a value if EITHER of these variables are in the column being looked at. Is this possible please? (example...one of the conditons is to look for stock that has a status of either "delivered" or "paid for".....both of which are amongst 5 different staus in the column...but I only need stock with EITHER these 2 status to be included) Thank you 
#2
Posted to microsoft.public.excel.misc




sumifs formula in excel 2007
you have to use two sum if's
=sumif(A:A,"Delivered",B:B)+sumif(A:A,"Paid for",B:B) Hope this helps "spudsnruf" wrote: Hello, within a sumifs formula, I am trying to include 2 variables withn one of the conditons (i have several conditons, but all others just need to look for 1 condition in 1 colum)..i need to return a value if EITHER of these variables are in the column being looked at. Is this possible please? (example...one of the conditons is to look for stock that has a status of either "delivered" or "paid for".....both of which are amongst 5 different staus in the column...but I only need stock with EITHER these 2 status to be included) Thank you 
#3
Posted to microsoft.public.excel.misc




sumifs formula in excel 2007
Just didnt think of that!. worked perfectly. thanks
"Engineering Accountant" wrote: you have to use two sum if's =sumif(A:A,"Delivered",B:B)+sumif(A:A,"Paid for",B:B) Hope this helps "spudsnruf" wrote: Hello, within a sumifs formula, I am trying to include 2 variables withn one of the conditons (i have several conditons, but all others just need to look for 1 condition in 1 colum)..i need to return a value if EITHER of these variables are in the column being looked at. Is this possible please? (example...one of the conditons is to look for stock that has a status of either "delivered" or "paid for".....both of which are amongst 5 different staus in the column...but I only need stock with EITHER these 2 status to be included) Thank you 
#4
Posted to microsoft.public.excel.misc




sumifs formula in excel 2007
Another one:
=SUM(SUMIF(A:A,{"Delivered","Paid for"},B:B)) spudsnruf wrote: Hello, within a sumifs formula, I am trying to include 2 variables withn one of the conditons (i have several conditons, but all others just need to look for 1 condition in 1 colum)..i need to return a value if EITHER of these variables are in the column being looked at. Is this possible please? (example...one of the conditons is to look for stock that has a status of either "delivered" or "paid for".....both of which are amongst 5 different staus in the column...but I only need stock with EITHER these 2 status to be included) Thank you  Dave Peterson 
#5
Posted to microsoft.public.excel.misc




sumifs formula in excel 2007
Thanks Dave, trid this too...as it seemed a little tidier...doesnt seem to
work though. WIll try again back home later, may be just a wrong comma or something my side. Thank you "Dave Peterson" wrote: Another one: =SUM(SUMIF(A:A,{"Delivered","Paid for"},B:B)) spudsnruf wrote: Hello, within a sumifs formula, I am trying to include 2 variables withn one of the conditons (i have several conditons, but all others just need to look for 1 condition in 1 colum)..i need to return a value if EITHER of these variables are in the column being looked at. Is this possible please? (example...one of the conditons is to look for stock that has a status of either "delivered" or "paid for".....both of which are amongst 5 different staus in the column...but I only need stock with EITHER these 2 status to be included) Thank you  Dave Peterson 
#6
Posted to microsoft.public.excel.misc




sumifs formula in excel 2007
Try copying directly from the postno need to retype it yourself.
spudsnruf wrote: Thanks Dave, trid this too...as it seemed a little tidier...doesnt seem to work though. WIll try again back home later, may be just a wrong comma or something my side. Thank you "Dave Peterson" wrote: Another one: =SUM(SUMIF(A:A,{"Delivered","Paid for"},B:B)) spudsnruf wrote: Hello, within a sumifs formula, I am trying to include 2 variables withn one of the conditons (i have several conditons, but all others just need to look for 1 condition in 1 colum)..i need to return a value if EITHER of these variables are in the column being looked at. Is this possible please? (example...one of the conditons is to look for stock that has a status of either "delivered" or "paid for".....both of which are amongst 5 different staus in the column...but I only need stock with EITHER these 2 status to be included) Thank you  Dave Peterson  Dave Peterson 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel 2007  SUMIFS formula use between tabs  Excel Discussion (Misc queries)  
SUMIFS Formula Problem  Excel Discussion (Misc queries)  
sumifs in excel 2003  Excel Worksheet Functions  
Excel 2007 SUMIFS  Excel Worksheet Functions  
[Excel 2007 Beta2] Function SUMIFS  Excel Worksheet Functions 