+ Reply to Thread
Results 1 to 4 of 4

Formula to Find matching values in one column, and return totals for all rows that match

  1. #1
    Registered User
    Join Date
    12-26-2013
    Location
    USA
    MS-Off Ver
    O365
    Posts
    8

    Formula to Find matching values in one column, and return totals for all rows that match

    table1.jpg

    I am looking for a formula that will satisfy the following:

    1) find all the values in column "A" that match
    2) In column "G", sum up all the values in "F" that go with the matching values in column "A"
    3) For example, in rows 14-16, the values in column "A" match. Cell G16 sums up F14:F16

    Thanks!

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Formula to Find matching values in one column, and return totals for all rows that mat

    In G2, then copy down.

    =IF(COUNTIF(A:A,A2)=COUNTIF(A$2:A2,A2),SUMIF(A:A,A2,F:F),"")
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    12-26-2013
    Location
    USA
    MS-Off Ver
    O365
    Posts
    8

    Re: Formula to Find matching values in one column, and return totals for all rows that mat

    table2.jpg

    Haseeb A, thank you. This formula works mostly but on some cells (see cells in "red") the formula does not return a value.

  4. #4
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Formula to Find matching values in one column, and return totals for all rows that mat

    Sorry for the late response,

    My previous formula only sum values in last occurrence of an order#. If you are getting blank means that particular order# will be down some where, or you did not use correct absolute reference in 2nd COUNTIF A$2:A2. Could you please attach a spreadsheet instead of screen shot?

+ 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. Replies: 1
    Last Post: 07-03-2013, 12:14 AM
  2. [SOLVED] Formula to match data ( multi column) in different sheets and return matching values
    By kangyao in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-17-2013, 08:49 PM
  3. [SOLVED] Formula to match data in different sheets ( multi column) and return matching values
    By kangyao in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-11-2013, 07:38 PM
  4. Replies: 10
    Last Post: 10-23-2012, 12:56 PM
  5. match 3 criteria in 1 table , find a matching row then return value from that row
    By bokusale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2012, 12:48 PM

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