+ Reply to Thread
Results 1 to 7 of 7

SUMIFS for Organizing Age Range

  1. #1
    Registered User
    Join Date
    08-11-2022
    Location
    Dublin, Ireland
    MS-Off Ver
    MS 365
    Posts
    1

    SUMIFS for Organizing Age Range

    Hello! Im currently working on my thesis regarding affinity towards nuclear energy based on age range. Im trying to organize my data based on how each age range feels regarding the question at hand (in the image attached each row represents a response). I need to summarize the responses for the age ranges so that I can graph each category. I've attempted using SUMIFS but every time I do so I get an error message stating 'SUMIFS expects all arguments after position three to be in pairs'. An example of something I've tried is '=SUMIFS(A2:A1383,"25-34",B2:B1383,"Agree"). Is there any way I can fix this or do I need to use a different function all together? Any and all help is greatly appreciated!Screen Shot 2022-08-11 at 3.51.13 PM.png

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: SUMIFS for Organizing Age Range

    Suspect you need COUNTIFS, not SUMIFS.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365 for MAC
    Posts
    3,105

    Re: SUMIFS for Organizing Age Range

    I think you need a COUNTIFS

  4. #4
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    Re: SUMIFS for Organizing Age Range

    Attachment 791274

    I agree with the above this is probably what you are looking for.
    The Formula used was
    Please Login or Register  to view this content.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: SUMIFS for Organizing Age Range

    Ok, so:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    With this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    you don't need the equals and ampersands.

    So, just this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Unfortunately, the attachment is invalid

  6. #6
    Forum Contributor
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2016
    Posts
    120

    Re: SUMIFS for Organizing Age Range

    Thank You TMS.

    It slipped my mind that you did not need it the image was a Graph that put Ages on one axis and Answers on another axis to give the data needed.

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: SUMIFS for Organizing Age Range

    It also can be done with a pivot table.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Sumifs formula not summing numerical range based on date range
    By jonnyp47 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2022, 10:27 PM
  2. 2 Way Sumifs with range
    By sd444 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-30-2019, 04:58 AM
  3. SUMIFS - Across Date Range, Time Range, and by City
    By awilliams8976 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2016, 06:51 PM
  4. sumifs on a pivot table - compare range with range
    By pavlos in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 02:26 AM
  5. Re--organizing Data from Cell Range: List all occurences under one category label
    By dmarzo1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-15-2013, 09:36 AM
  6. Organizing range of cells using VBA.
    By Cyberpawz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2012, 03:16 PM
  7. Excel 2007 : Organizing a range of data into a new column
    By Cuckooguy in forum Excel General
    Replies: 2
    Last Post: 06-27-2010, 07:11 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1