Results 1 to 20 of 20

Summing based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2010
    Location
    Tennessee
    MS-Off Ver
    Excel 2003
    Posts
    12

    Summing based on multiple conditions

    I have been trying to search an array and cannot find the correct combination of functions to get the information I want. I might need a macro to do this but I will try anything. Here is an example:

    1 A 1
    1 B 2
    2 A 3
    2 B 4
    3 A 5
    3 B 6

    I want to search for 3 and A and return the value in the 3rd column. I have tried several functions but cant figure out how to make sure I get the correct value in the 2nd column that corresponds to the value in the 1st column.

    Thank for your help.
    Last edited by confu5ion; 02-11-2010 at 11:02 AM.

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