+ Reply to Thread
Results 1 to 2 of 2

Add numbers in a column that meet criteria and find the maximum sum

  1. #1
    Registered User
    Join Date
    12-31-2013
    Location
    Raleigh, NC, USA
    MS-Off Ver
    Excel 2013
    Posts
    1

    Add numbers in a column that meet criteria and find the maximum sum

    Hi All,

    I'm developing a spreadsheet for a nonprofit that provides feedback on their major fundraiser/auction. I'm trying to create a formula in a cell that will look at the bidder #'s in column B and add the value of the their purchased items found in column C and return the number of the bidder that has the largest total value of purchases.

    This can be done with a pivot table and give a table of all bidders, their total amount paid for items, and the number of items purchased.

    thanks for your assistance.
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Add numbers in a column that meet criteria and find the maximum sum

    Do you really need a formula?
    If you create a pivot table based on the Bid Winner and Final Bid columns, you'll be able to filter the Bid Winners for the Top 1 based on Sum of Final Bid.

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ 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] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  2. Searching Data and Summing numbers that meet the criteria
    By excel2425 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-13-2013, 02:24 PM
  3. Replies: 9
    Last Post: 04-15-2012, 11:51 AM
  4. [SOLVED] how do I count the numbers of row that meet 2 criteria
    By Debi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-10-2005, 06:00 PM
  5. [SOLVED] Formula that only adds numbers that meet specific criteria
    By Elizabeth in forum Excel General
    Replies: 10
    Last Post: 10-12-2005, 07:05 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