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.

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.