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)



"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!

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!

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!