sumif with 2 criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sumif and - 06 Mar 2008 21:12 GMT

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!

Reply to this Message

Bob Phillips - 06 Mar 2008 21:25 GMT

why do you need SUM when there is only one field. Use

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

Signature

---
HTH

Bob

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

> Trying to do a formula as follows:
>
[quoted text clipped - 10 lines]
>
> This seems simple, but I am getting hung up somewhere. Please help!

Reply to this Message

sumif and - 06 Mar 2008 21:58 GMT

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

> why do you need SUM when there is only one field. Use
>
[quoted text clipped - 14 lines]
> >
> > This seems simple, but I am getting hung up somewhere. Please help!

Reply to this Message

Bob Phillips - 06 Mar 2008 22:15 GMT

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.

Signature

---
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
[quoted text clipped - 24 lines]
>> >
>> > This seems simple, but I am getting hung up somewhere. Please help!

Reply to this Message