M
martinbarnes
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.
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.