+ Reply to Thread
Results 1 to 5 of 5

SUMIF Different Colomns based on different criteria

Hybrid View

  1. 10-01-2015, 07:18 AM #1
    zendetta2608
    zendetta2608 is offline
    Registered User
    Join Date
    10-01-2015
    Location
    london
    MS-Off Ver
    2010
    Posts
    9

    Unhappy SUMIF Different Colomns based on different criteria

    Hi all - First off im new to all this so go easy on me...

    My whole reason for joining is im trying to solve a month old problem: I want to search a different column for data based on criteria in a cell.

    As an example

    If A1="B:B" then SUM Column B
    If A1="C:C" then SUM Column C
    If A1="D:D" then SUM Column D
    And so on….

    Maybe im looking at this in the wrong way, but to my data dump requires me to search a very large array of information that is different each week and so i need a flexible formula

    Thanks in advance (incase someone cant solve this, then thanks for trying)
    Reply With QuoteRegister To Reply
  2. 10-01-2015, 07:23 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,915

    Re: SUMIF Different Colomns based on different criteria

    I am not sure try below formula
    =SUM(INDIRECT(SUBSTITUTE(A1,"""",)))
    =SUM(INDIRECT(SUBSTITUTE(A1,"""",)))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
  3. 10-01-2015, 07:24 AM #3
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF Different Colomns based on different criteria

    Like this...

    Data Range
    A
    B
    C
    D
    1
    B:B
    10
    20
    30
    2
    100
    10
    20
    30
    3
    10
    20
    30
    4
    10
    20
    30
    5
    10
    20
    30
    6
    10
    20
    30
    7
    10
    20
    30
    8
    10
    20
    30
    9
    10
    20
    30
    10
    10
    20
    30


    This formula entered in A2:

    =SUM(INDIRECT(A1))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  4. 10-01-2015, 09:01 AM #4
    zendetta2608
    zendetta2608 is offline
    Registered User
    Join Date
    10-01-2015
    Location
    london
    MS-Off Ver
    2010
    Posts
    9

    Re: SUMIF Different Colomns based on different criteria

    Just wanted to say thanks to both of you. That was all i needed.
    Just for anyone else that would like to know - i was using this across more than one Sheet:

    =SUMIF(INDIRECT(A1),C2,Sheet2!B:B)
    A1 = Sheet2!A:A
    Reply With QuoteRegister To Reply
  5. 10-01-2015, 01:25 PM #5
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF Different Colomns based on different criteria

    You're welcome. We appreciate the feedback!

    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
    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. Compare 2 colomns from 2 tables and make the difference of another colomns between 2 table
    By luckyvasul in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-07-2014, 12:37 PM
  2. Compare diffrerent colomns based on one colomn
    By luckyvasul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-31-2014, 03:46 AM
  3. Problems with Autofilter, date as criteria which are in tow colomns
    By atkumar123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2013, 06:35 AM
  4. [SOLVED] Sumif Based on criteria
    By masond3 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2013, 04:26 AM
  5. [SOLVED] Sumif two colomns to ignore if a value is present
    By nickmax1 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 01-21-2013, 10:45 AM
  6. Vlookup based on 2 colomns
    By Gtrhero in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-09-2007, 06:11 PM
  7. SumIf based on two criteria
    By Mark Williams in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2005, 02:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1