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.