formula help

  • Thread starter Thread starter sross002
  • Start date Start date
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.
 
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.
 
Back
Top