Results 1 to 2 of 2

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

Threaded View

  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

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