if statements

[marksuza]

Hi, I was wondering if I could get some help, nothing hard I think.
tried using the Address function but could not work and the sumif doe
not accept multiple columns.

I have four columns 3 of which are check boxes and one of them
number. I want to say something like this:

If column A is true Sumif column 2 is true.

Pending LA NY Amount
Y Y 10
Y Y 15
Y Y 5
Y Y 10
Y 20

So LA would equal 25 and NY 15. Thanks guys.

Marco

 

[Peo Sjoblom]

Select the cell and do format>conditional formatting and if there is
something there click the delete
button and select all three conditions

 

[Andy B]

Hi

Try using SUMPRODUCT:

=SUMPRODUCT((A2="Y")*(B2="Y")*(D2)) for LA
=SUMPRODUCT((A2="Y")*(C2="Y")*(D2)) for NY

Andy

 

[Peo Sjoblom]

Well that was supposed to answer the Fill Colour post.
Sorry about that..

--

Regards,

Peo Sjoblom

Select the cell and do format>conditional formatting and if there is
something there click the delete
button and select all three conditions