Results 1 to 20 of 20

Summing based on multiple conditions

Threaded View

confu5ion Summing based on multiple... 02-11-2010, 09:56 AM
NBVC Re: Excel Formula or Macro 02-11-2010, 09:59 AM
confu5ion Re: Excel Formula or Macro 02-11-2010, 10:16 AM
confu5ion Re: Excel Formula or Macro 02-11-2010, 10:32 AM
confu5ion Re: Excel Formula or Macro 02-11-2010, 10:58 AM
confu5ion Re: Excel Formula or Macro 02-11-2010, 11:00 AM
NBVC Re: Summing based on multiple... 02-11-2010, 10:01 AM
NBVC Re: Summing based on multiple... 02-11-2010, 10:27 AM
NBVC Re: Summing based on multiple... 02-11-2010, 10:38 AM
confu5ion Re: Summing based on multiple... 02-11-2010, 02:52 PM
NBVC Re: Summing based on multiple... 02-11-2010, 02:56 PM
confu5ion Re: Summing based on multiple... 02-11-2010, 03:03 PM
NBVC Re: Summing based on multiple... 02-11-2010, 03:07 PM
confu5ion Re: Summing based on multiple... 02-11-2010, 03:44 PM
NBVC Re: Summing based on multiple... 02-11-2010, 03:46 PM
NBVC Re: Summing based on multiple... 02-11-2010, 05:50 PM
confu5ion Re: Summing based on multiple... 02-11-2010, 03:58 PM
NBVC Re: Summing based on multiple... 02-11-2010, 04:10 PM
confu5ion Re: Summing based on multiple... 02-11-2010, 05:41 PM
confu5ion Re: Summing based on multiple... 02-11-2010, 06:14 PM
  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