sumif with 2 criteria

  • Thread starter Thread starter sumif and
  • Start date Start date
S

sumif and

Trying to do a formula as follows:

Sheet1 Sheet2
Account # Monthly YTD Account # Code YTD
510000 5,000.00 15,000.00 510000 Expense $50,000.00

Formula not working:
=SUM(IF(((B4='Account Type'!C291)*(Input!B291="A")),Input!H291,""))

So, if Sheet1 Account # = Sheet2 Account # and Sheet2 Code = Expense, then
give me the sum of Sheet1 YTD

This seems simple, but I am getting hung up somewhere. Please help!
 
why do you need SUM when there is only one field. Use

=IF(AND(B4='Account Type'!C291,Input!B291="A"),Input!H291,"")


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Well....it is a bit more complicated that this, because on Sheet1 I may have
multiple rows in which it finds 510000, so I am going to have to sum all hits
of that account.

I'll try it.....
 
Which is Sheet1, the one with B4, 'Account Type', or 'Input'? If you have
510000 in one test you must have 510000 in the others.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top