Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum data with multiple criteria
I am trying to sum data in one column (G) that satisfy multiple criteria in
other columns (R,B, and J). The formula i tried to use (and didn't work) is below: =IF(AND($R$24:$R$27=$T$22,$B$24:$B$27=$S$23),SUMIF ($J$24:$J$27,"<100",$G$24:$G$27),0) So basically I am trying to find the total balance of accounts that meet 3 different criteria: specific account name (col. 1), "good" or "bad" account (col. 2), less than 100 days old (col. 3). If all these criteria are met I need to add account balances in a separate column. Anny suggestions would be most helpful. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum data with multiple criteria
Hi,
I got confused when you started taling about columns 1 & 2 & 3 However, Try this =SUMPRODUCT((B1:B9="Good")*(R1:R9(A3-100))*(G1:G9)) A3 contains todays date Mike "martinbarnes" wrote: I am trying to sum data in one column (G) that satisfy multiple criteria in other columns (R,B, and J). The formula i tried to use (and didn't work) is below: =IF(AND($R$24:$R$27=$T$22,$B$24:$B$27=$S$23),SUMIF ($J$24:$J$27,"<100",$G$24:$G$27),0) So basically I am trying to find the total balance of accounts that meet 3 different criteria: specific account name (col. 1), "good" or "bad" account (col. 2), less than 100 days old (col. 3). If all these criteria are met I need to add account balances in a separate column. Anny suggestions would be most helpful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Sum multiple arrays of data according to criteria | Excel Worksheet Functions | |||
multiple data validation criteria | Excel Discussion (Misc queries) | |||
finding data with multiple criteria | Excel Discussion (Misc queries) | |||
Sorting Data by multiple criteria | Excel Discussion (Misc queries) |