excel.bigresource.comSumming Based On Multiple Conditions

Submit Resource Tracker Forum Advance Search Feb 11, 2010 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. View 14 Replies Similar Messages: Summing With Multiple Conditions Summing If Multiple Conditions Are True Summing Ranges Based On Two (or More) Conditions/criteria Summing Values From Array W/ Multiple Conditions-cols Summing Data From Multiple Workbooks Based On Multiple Criteria Summing Values Based On Multiple Categories Summing Data Based On Multiple Criteria Summing Multiple Items Based On A String In A Cell? Summing Values From Multiple Worksheets Based On Rows And Columns Sum Based On Multiple Conditions Excel 2007 :: Summing Column On Data Sheet Based On Multiple Criteria VBA To Set Cell Value Based On Multiple Conditions Cell Value Based On Multiple Conditions Average Based On Multiple Conditions Summing First 5 Numbers In Range With Conditions? Summing Values Using Specific Conditions Summing Data That Meets Two Conditions Flagging Duplicates Based On Multiple Conditions Lookup Unique Based On Multiple Conditions ... Counts Info Based On Multiple Conditions Finding Information Based Upon Multiple Conditions Match Function Based On Multiple Conditions In VBA Delete Cells Based On Multiple Conditions? Lookup Value From List Based On Multiple Conditions Create New List Based On Multiple Conditions Sum Based On Multiple Conditions & Variable Range Identifying Rows To Delete Based On Multiple Conditions? Return Data From Table Based On Multiple Conditions Record Duplicate Values Based On Multiple Conditions Only ADVERTISEMENT Summing With Multiple Conditions May 19, 2008 I need to sum the items in column G12:G39 with the 1st name in Column B12:B39 which could be 1 of 9 different names, that, and the 2nd name in column D12:D39 cannot not say either #4 or TE. If it says #4 or TE, then it needs to sum the info in colmn G12:G39, based on the 1st name in column B12:B39. View 9 Replies View Related Summing If Multiple Conditions Are True Mar 27, 2007 I could probably fix by making a loop, but I am trying to avoid doing any more looping. The program that I am working on has way too much looping in it already, and is getting kind of bogged down. Here is what I need. On my worksheet, column D lists the names of farms, column E lists a specific chicken house on that farm (by number), and column F lists how many chicks are being placed into that house. What I need to do is find a way, within VBA, to add up all of the chicks in column F that correspond to a certain farm name (column D) and chicken house (column E). I can make something like this work in excel, but not in VBA. For example, if I wanted to find out how many chicks were being delivered to Johnson Farms, house 4, I would use this formula: = SUM(IF(($D$5:$D$25="JOHNSON FARMS") * ($E$5:$E$25=3),$F$5:$F$25 )) View 9 Replies View Related Summing Ranges Based On Two (or More) Conditions/criteria Jul 7, 2009 I have a cell that I need to make a calculation if certain other cells =Y, or to show "0" if the other cells =N. I can do the calculation for the Y part but how do I add the N part of it? Here is what I have: =SUMIF(J19:J40,"Y",H19:H40)*0.08 View 13 Replies View Related Summing Values From Array W/ Multiple Conditions-cols Oct 1, 2007 I know there have been many posts about multiple conditions in arrays, but I didn’t find one that applied to my situation, so I’m hoping can help me out of jam. I’m using Excel 2000 on XP. I have a database of sales information. Customer name is listed in column C, and columns F through Q contain the sales for the months of July - June (fiscal calendar year), with the headers for the months in row 4. There can be many rows of sales for the same customer, hence the need to sum them. Example C F G H CUSTOMER JULY AUGUST SEPTEMBER customer1 2 3 4 customer1 2 3 4 customer2 2 3 4 customer2 2 3 4 The problem is that this information will need to be updated every month to reflect sales year-to-date, meaning that the conditions for summing the data will change depending on how far into the year we are. So for instance, in August I will need to sum all the records for customer1 in the July column (column F) and the August column (column G), but next month it will have to sum the records for customer1 from July, August, and September (col H). The result of this information would be displayed on a different worksheet. My thought was to assign a range of 12 cells (Sheet2!A1:A12) and to populate those cells with any of the months that need to be summed thus far. So for example, through September, A1 = "July", A2 = "August", and A3 = "September". Then the formula would use those values to evaulate the conditions. So in plain English the formula would: sum the values in columns F : Q where the monthly header = the values in the range Sheet2!A1:A12 for all records where CUSTOMER = CustomerName View 9 Replies View Related Summing Data From Multiple Workbooks Based On Multiple Criteria May 14, 2014 I track distribution using 1 workbook for each sales rep. Each workbook has a separate worksheet (scorecard) for each of their locations showing which of our products are used in that location, for various functions. Each of the locations has a segment (bar, nightclub, casual dining, etc.), and a class (AA, A, B, etc.). All of the scorecards are identical, and are in the same file folder on our shared drive. Sample: Location A Class:AA Segment: Sports Bar Rep: John Smith Product: Product X Product Y Product Z Well: 1 0 0 Back Bar: 0 1 0 Cocktail Menu: 0 1 1 I was unable to find an HTML maker so this is not an actual sample but what I’m looking at. The above data indicates that for location A (Sports Bar, Class AA), Product X is used as the well, Product Y is on their back bar and their cocktail menu, and Product Z is not used at this location at all. I need to set up an analytic workbook where I can sum data based on multiple and grouped criteria, and for multiple reps ie- display a scorecard that shows totals for nightclubs and sports bars, class AA, A, and B, for a particular rep; OR display a scorecard that shows totals for nightclubs, class A for a group of reps. Ideally I would like to do this using drop down menus that allow the user to select multiple criteria in each of the drop downs, having the data auto-populate based on those selections. View 2 Replies View Related Summing Values Based On Multiple Categories Jul 22, 2014 I am trying to create an inventory control system that keeps tracks of what’s in bins based on additions and subtractions to the bin. I am hoping to generate a summary output of bin contents based on the transaction list. I know how to do this using pivot tables, but am looking for a VBA or excel function solution since I will have hundreds of bins and thousands of transactions. Bin number Product Code Pounds 1 A 50 1 A -25 [Code] ...... I want to have the following table auto generated. Bin Product Code Sum Quantity 1 A 25 1 D 75 [Code] ....... I’m using an array formula right now, but it is proving to be extremely slow. =IF(ISERROR(INDEX(’Harvest Generator’!$E:$I,SMALL(IF(LEFT(’Harvest Generator’!$E:$E,LEN(’Harvest Generator’!$E:$E))=LEFT(B$3,LEN(B$3)),ROW(’Harvest Generator’!$E:$E)),ROW(1:1)),B$2)),"",INDEX(’Harvest Generator’!$E:$I,SMALL(IF(LEFT(’Harvest Generator’!$E:$E,LEN(’Harvest Generator’!$E:$E))=LEFT(B$3,LEN(B$3)),ROW(’Harvest Generator’!$E:$E)),ROW(1:1)),B$2)) Where Harvest Generator is the sheet where my table is on. View 2 Replies View Related Summing Data Based On Multiple Criteria Sep 22, 2009 I have a table of data: - In cell A1:...