+ Reply to Thread
Results 1 to 3 of 3

HELP! Need Sumif formula that references a different sheet

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    19

    Exclamation HELP! Need Sumif formula that references a different sheet

    Looking to create a formula in the yellow highlighted area that will search for The value in column H in the "overview" sheet, and sum together the corresponding values in the Calculations chart. The formula should also only sum up the values in either Control or Test depending on what column it belongs to.

    For example, In cell I2, it should sum together 83+53.

    - According to Overview sheet, Consideration (A5) has values "Somewhat likely" and "very likely"
    - Therefore, the 53 refers to Consideration "somewhat likely" while 83 refers to Consideration "Very Likely" in Control column of Calculations Sheet


    Is such formula possible? or do i need to break this down more?? Appreciate any help!
    Attached Files Attached Files

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: HELP! Need Sumif formula that references a different sheet

    This formula will do what you need:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Same formula goes for Test column but uses column D to sum.
    See attached.
    Attached Files Attached Files
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Registered User
    Join Date
    06-17-2020
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    19

    Re: HELP! Need Sumif formula that references a different sheet

    thank you SO MUCH!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula References Other Sheet But Errors
    By Logit in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-07-2020, 03:43 PM
  2. Multiple references in one formula. Tried SUMIF, VLOOKUP, INDEX, and MATCH.
    By lazers26 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2019, 10:23 AM
  3. Auto fill formula to last row, formula references another sheet
    By Cheesecube in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-20-2018, 12:31 PM
  4. Replies: 5
    Last Post: 02-18-2011, 05:27 AM
  5. Repetitive sheet references in formula
    By eugbed in forum Excel General
    Replies: 3
    Last Post: 05-01-2010, 12:33 AM
  6. =sumif() giving VALUE# error when mixing sheet references
    By pickslides in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2009, 01:58 AM
  7. Copy Formula That References Another Sheet
    By JR573PUTT in forum Excel General
    Replies: 9
    Last Post: 02-16-2006, 06:24 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1