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)
"sumif and" wrote in message
...
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.....
"Bob Phillips" wrote:
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)
"sumif and" <sumif wrote in message
...
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!