counting named in a row

T

torsorq

Hi
I want to have 32 names in row A2:33 and each name at a 1 in row
B2:B33....if the name is in a disqualified list C2:C20 then make a -1 for
those names. if the same name act in another 32 names then add 1 to the first
1 =2, but still if the name is disqualified list : -1 .... is this simple ?
btw i´m very green

/Torsorq
 
P

Peo Sjoblom

=-1*(COUNTIF($C$2:$C$20,A2)>0)

will return minus 1 for disqualified

=1*(COUNTIF($D$2:$D$33,A2)>0)

will return 1 for another 32 names list (assuming they are in D2:D33)

then use if function to test each row like

If you put the first formula in E2:E32 and the second formula
in F2:F32 in G2:G32 use

=If(E2=-1,-1,B2+F2)

copy down


--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlinks with lookups 0
Combine 2 columns in a dynamic range into one 7
Data Validation and drop-down list using IF, AND and what else? 8
Auto copy data rows between sheets depending on date entry 3
Count Non-Empty Cells In Each Row 0
Data Validation 4
Match, Index, Not sure 0
Transpose with Match ? 4

Top