+ Reply to Thread
Results 1 to 2 of 2

Sumifs problem

  1. #1
    Registered User
    Join Date
    12-03-2014
    Location
    Washington DC
    MS-Off Ver
    Excel 2010
    Posts
    10

    Sumifs problem

    Hi

    In Column A I have a specific value, and in column B I have like a value range (the value range from 10000-90000 in column B). I'm given a range that I have to sum it up. For example from each value in column B has a specific value in column A. in column B, there is 40000 and that 40000 has a specific value of 300,120 dollars (the 300,120 dollars is in column A). I have to sum up the specific values from range 40000-59999 to get the Sumifs.

    How do I use the SUMifs formula to get the sum?
    If you guys don't understand what I'm saying, I'll try to explain it a better way.

    Thanks
    Soul24rage

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Sumifs problem

    If I understand...

    =SUMIFS(A:A,B:B,">=40000",B:B,"<=59999")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Problem with SUMIFS
    By SharpL in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-27-2014, 08:07 AM
  2. problem with SUMIFS
    By sbidgol in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-11-2014, 06:37 PM
  3. [SOLVED] Sumifs, problem with the formula: =sumifs(c10:c200,<=today(),0)
    By Faustocruz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-08-2012, 04:26 AM
  4. Excel 2007 : Sumifs problem
    By Bee&H in forum Excel General
    Replies: 2
    Last Post: 11-30-2011, 12:29 PM
  5. SUMIFS Problem
    By denise001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2011, 08:38 AM

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