Hello,

I have Office 2004 on my PC.

I don't know what formula (hlookup, sumif, etc) I can use for the following
issue:

Y or N N Y Y N
Y or N Y Y N Y
Joe 5 2 1 10

I want to add up the numbers for Joe but only if it has a Y. If there are
two Y's in the column then the number should add twice. In this example, I
should have an answer of 20.

Can someone help me with a formula to compute this?

Thanks in advance.

Try the following formula

=SUMIF(D4:G4,"Y",D6:G6)+SUMIF(D5:G5,"Y",D6:G6)

Replace D4:G4 & D5:G5 with your Y and N rows and replace D6:G6 with the
values row.

thanks.

"Gilbert" wrote:

Try the following formula

=SUMIF(D4:G4,"Y",D6:G6)+SUMIF(D5:G5,"Y",D6:G6)

Replace D4:G4 & D5:G5 with your Y and N rows and replace D6:G6 with the
values row.