Results 1 to 4 of 4

Return sum of values in column when matching and also when Row matches input

Threaded View

  1. #1
    Registered User
    Join Date
    10-21-2009
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Return sum of values in column when matching and also when Row matches input

    In the attached sheet, I have many products listed in columns, and the columns repeat with the following (Purc. #, Cost, Cust. Inv )

    I am needing help making a formula that will, sum the total cost for the a specified Purch. # and specified product id.

    I have tried all sorts of ways to do this but a search based on two inputs is too difficult for myself to works out. I thought it would be easy at first, but no luck after trying for hours.

    I hope someone has an idea how this can be solved and Iam fascinated with what the solution is.

    Thanks
    Dave

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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