+ Reply to Thread
Results 1 to 4 of 4

Is it possible to build a sum based on conditions?

  1. 05-20-2019, 08:42 PM #1
    sewercider
    sewercider is offline
    Registered User
    Join Date
    10-22-2018
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    17

    Is it possible to build a sum based on conditions?

    Hi all,

    I am wondering if it is possible to build a sum based on conditions.

    Example:

    data.JPG

    I would like to get a total volume for all cells that contain the word cancer (in this case it would be 124,000 as 'malignant' and 'benign' would be excluded).

    If anyone can shed some light on this, that would be awesome!

    Cheers!
    Reply With QuoteRegister To Reply
  2. 05-20-2019, 10:25 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Is it possible to build a sum based on conditions?

    Try

    =SUMIF(A:A,"*cancer*",B:B)



    A
    B
    1
    Keyword
    Volume
    2
    skin cancer
    20,000
    3
    cancer
    20,000
    4
    prostate cancer
    18,000
    5
    pancreatic cancer
    16,000
    6
    bowel cancer
    14,000
    7
    benign
    13,000
    8
    breast cancer
    13,000
    9
    ovarian cancer
    12,000
    10
    lung cancer
    11,000
    11
    malignant
    10,000
    Dave
    Reply With QuoteRegister To Reply
  3. 05-21-2019, 12:22 AM #3
    sewercider
    sewercider is offline
    Registered User
    Join Date
    10-22-2018
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    17

    Re: Is it possible to build a sum based on conditions?

    Wow, this is awesome (and looks way simpler than I imagined), thank you!!!
    Reply With QuoteRegister To Reply
  4. 05-21-2019, 12:43 AM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Is it possible to build a sum based on conditions?

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Build an assembly based on the components list
    By thup_98 in forum Excel General
    Replies: 17
    Last Post: 12-28-2015, 12:04 AM
  2. Need help to build a formula to calculate support time based on some conditions
    By achena in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-14-2013, 08:45 AM
  3. Build lists based on criteria
    By TigerCole in forum Excel General
    Replies: 3
    Last Post: 10-05-2012, 11:32 AM
  4. VBA - Build ListBox based on multiple worksheets
    By helpmeplz55 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-26-2012, 10:42 AM
  5. Excel 2007 : ID build qty based on lowest cycle time
    By gfunk in forum Excel General
    Replies: 3
    Last Post: 06-15-2012, 07:57 PM
  6. [SOLVED] Trying to build list based on cell value
    By [email protected] in forum Excel General
    Replies: 5
    Last Post: 04-30-2006, 12:59 PM
  7. CONCATENATE within links to build different filenames based on for
    By Captain Scarlett in forum Excel General
    Replies: 3
    Last Post: 04-13-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1