Sumif (Excel 2000)

Topic

New Reply

Hi all,

i’m working with a Database that I created, in Excel. What I would like to accomplish is to give a value to a cell, based on the conditional value of three different cells, so if A1 = “A” and B1= B and C1=C then D1 = 1, but if it doesn’t match any of those it would equal 0. These cell are all offset to one another, and the range will change because I have it so that at the end of every entry into the Database there is a new row, ready for the next input.

The reason for the value is so that I can graph it.

Has anyone see a post that might help me get started?

Thanks,

Darryl.

Reply | Quote

Replies

Sorry, could you try to explain that more slowly, with some more examples?

Reply | Quote

Thanks For your reply,

The Formula worked great thank you.

Reply | Quote

I love this place. I can’t count the number of times someone has come thru for me, given me an idea, or posted some code I can tweak.

Reply | Quote

I’m sure you meant to thank notbrl.

Reply | Quote

How bout this:

=IF(AND(A1=”A”,B1=”B”,C1=”C”),1,0)

Reply | Quote

[indent]

---

How bout this:

=IF(AND(A1=”A”,B1=”B”,C1=”C”),1,0)

---

[/indent]

The other approach is:
= (A1=”A”) * (B1=”B”) * (C1=”C”)

Reply | Quote

Thanks kindly for your reply notbrl:)

Darryl.

Reply | Quote