1. ## Sumif (Excel 2000)

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.

2. ## Re: Sumif (Excel 2000)

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

3. ## Re: Sumif (Excel 2000)

How bout this:

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

4. ## Re: Sumif (Excel 2000)

The Formula worked great thank you.

5. ## Re: Sumif (Excel 2000)

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.

6. ## Re: Sumif (Excel 2000)

I'm sure you meant to thank <!profile=notbrl>notbrl<!/profile>.

7. ## Re: Sumif (Excel 2000)

<hr>How bout this:

=IF(AND(A1="A",B1="B",C1="C"),1,0) <hr>

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