+ Reply to Thread
Results 1 to 3 of 3

Formular to sum up the values for unique numbers in a column

  1. #1
    Registered User
    Join Date
    09-17-2020
    Location
    Lagos
    MS-Off Ver
    2016
    Posts
    3

    Question Formular to sum up the values for unique numbers in a column

    Please see below to assist:
    Age Books required Total books required for each age grade
    1 5
    1 7
    1 9
    5 20
    5 15
    12 30
    12 5
    12 14
    12 14
    12 2

  2. #2
    Registered User
    Join Date
    02-04-2019
    Location
    Essex
    MS-Off Ver
    2016
    Posts
    39

    Re: Formular to sum up the values for unique numbers in a column

    Hi,

    I'm sorry but this makes no sense? Have you got a sheet you could attached with a bit more blurb to explain what you are looking to achieve?

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,129

    Re: Formular to sum up the values for unique numbers in a column

    Assuming Age in column A, Book in column B

    In A1

    =IF(A1=A2,"",SUMIF(A:A,A1,B:B))

+ 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] Flag whether a unique or matching number follows 3 unique numbers immediately in a column
    By Supersadie in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-07-2018, 01:54 AM
  2. Replies: 12
    Last Post: 07-12-2017, 04:01 PM
  3. Replies: 2
    Last Post: 08-19-2015, 10:22 AM
  4. Replies: 3
    Last Post: 10-15-2012, 10:42 AM
  5. Replies: 3
    Last Post: 09-22-2012, 01:11 AM
  6. [SOLVED] Array formular - Return only unique values
    By jackyong1985 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-20-2012, 07:17 AM
  7. Count Unique Values In One Column Basis Unique Values in Another Column
    By shez_raz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-07-2012, 01:55 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