Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default sumifs formula in excel 2007

Try copying directly from the post--no 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - SUMIFS formula use between tabs Terry Excel Discussion (Misc queries) 2 October 9th 07 03:59 PM
SUMIFS Formula Problem Keith Excel Discussion (Misc queries) 5 August 2nd 07 09:41 PM
sumifs in excel 2003 Lok Tak Cheong Excel Worksheet Functions 6 June 25th 07 07:27 PM
Excel 2007 SUMIFS [email protected] Excel Worksheet Functions 2 April 26th 07 07:12 AM
[Excel 2007 Beta2] Function SUMIFS Franz Verga Excel Worksheet Functions 3 June 20th 06 11:53 PM


All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"