S
sross002
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.
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.