# [SOLVED] counting named in a row

1. ## [SOLVED] counting named in a row

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

2. ## Re: counting named in a row

=-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

"torsorq" <torsorq@discussions.microsoft.com> wrote in message
news:49A8282D-C51A-49EE-8642-B291C11F8076@microsoft.com...
> 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

3. ## Re: counting named in a row

sorry can´t get it to work ...have You tested it ?

/Torsorq

"Peo Sjoblom" wrote:

> =-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
>
>
>
> "torsorq" <torsorq@discussions.microsoft.com> wrote in message
> news:49A8282D-C51A-49EE-8642-B291C11F8076@microsoft.com...
> > 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

>
>

4. ## Re: counting named in a row

Yes

--
Regards,

Peo Sjoblom

"torsorq" <torsorq@discussions.microsoft.com> wrote in message
news:62CDA965-589E-4E0B-AA4B-45B167CDAF64@microsoft.com...
> sorry can´t get it to work ...have You tested it ?
>
> /Torsorq
>
> "Peo Sjoblom" wrote:
>
>> =-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
>>
>>
>>
>> "torsorq" <torsorq@discussions.microsoft.com> wrote in message
>> news:49A8282D-C51A-49EE-8642-B291C11F8076@microsoft.com...
>> > 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

>>
>>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1