Results 1 to 6 of 6

Thread: Sum Between Values Within The Same Range

  1. #1
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13

    Sum Between Values Within The Same Range

    Hi Guys,

    I have an excel list of Magazine quantities in Cell C. The list includes numbers from 1 to 1000. This list has repeating values too, that is 1 is present multiple times in the same list and so on.

    I need a formula to sum the following:
    Sum of all magazines with the quantity value of 1's
    Sum of all magazines with the quantity value between 2's & 9's (2's & 9's should be included too)
    Sum of all magazines with the quantity value between 10's & 24's (10's & 24's should be included too)
    Sum of all magazines with the quantity value between 25's & 49's (25's & 49's should be included too)
    Sum of all magazines with the quantity value between 50's & 99's (50's & 99's should be included too)
    Sum of all magazines with the quantity value greater than 100's (100 also to be included)


    Thanks,
    Siyab

  2. #2
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    You have used the term Sum. Does this mean you want to sum the values in Column c for each of the characteristics or you want a count of Column c for each of the characteristics. This is unclear in your request.

  3. #3
    Member
    Join Date
    Jun 2012
    Posts
    80
    Rep Power
    13
    I want the sum of the values in each category.

  4. #4
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    See attached worksheet example
    Attached Files Attached Files

  5. #5
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    Quote Originally Posted by alansidman View Post
    See attached worksheet example
    A slight tweak to C6's formula from
    Code:
    =SUMIFS($C$2:$C$1001,$C$2:$C$1001,">51",$C$2:$C$1001,"<100")
    to
    Code:
    =SUMIFS($C$2:$C$1001,$C$2:$C$1001,">49",$C$2:$C$1001,"<100")

  6. #6
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    13
    @p45cal

    Thanks for finding and fixing that.

    Alan

Similar Threads

  1. Replies: 3
    Last Post: 08-10-2013, 09:42 PM
  2. Replies: 8
    Last Post: 04-29-2013, 08:36 PM
  3. Replies: 11
    Last Post: 04-07-2013, 07:51 PM
  4. Sum values based on multiple criteria
    By Jorrg1 in forum Excel Help
    Replies: 8
    Last Post: 01-07-2013, 03:04 PM
  5. Sum values based on multiple criteria
    By vmath in forum Excel Help
    Replies: 1
    Last Post: 05-07-2012, 08:53 AM

Posting Permissions

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