Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
How do I use SUMIF or another function to add a column of figures based on
criteria in two adjacent columns? The criteria can be either true or false. For example, in one instance I might want to add figures based on a match in a Column A and B and in another instance based on a match in Column A but not B. I am using Excel 2003. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
How does the formula know what criteria you want in each case?
Dave. "Setts" wrote: How do I use SUMIF or another function to add a column of figures based on criteria in two adjacent columns? The criteria can be either true or false. For example, in one instance I might want to add figures based on a match in a Column A and B and in another instance based on a match in Column A but not B. I am using Excel 2003. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
In each case for the criteria I select two adjacent cells, one containing a
stock symbol, e.g. MSFT for Microsoft, and the other an Option symbol. When the criteria match, in this case MSFT and blank, I want to add up a figure in a third column. In other cases I want to add up when the stock symbol matches and the adjacent column is NOT blank. I am familiar with the SUMIF function but want the first two arguments to identify two columns. "Dave" wrote: How does the formula know what criteria you want in each case? Dave. "Setts" wrote: How do I use SUMIF or another function to add a column of figures based on criteria in two adjacent columns? The criteria can be either true or false. For example, in one instance I might want to add figures based on a match in a Column A and B and in another instance based on a match in Column A but not B. I am using Excel 2003. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Function
Hi,
One way is with SUMPRODUCT. With your stock symbol data in C2:C100 With your option symbol data in D2:D100 With your figures to add in E2:E100 Type the stock symbol you want as criteria into F2 Type the option symbol you want as criteria into G2 =SUMPRODUCT(--(C2:C100=F2)*(D2:D100=G2)*(E2:E100)) Regards - Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to nest a left function within a sumif function? | Excel Worksheet Functions | |||
Using the TODAY() function in a SUMIF function | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
Can SUMIF function include AND function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |