Hello Stefi,
Iwant formula result in column c only.your formula has range d2:d7 also.It's
not giving any result what I desire.Please go through my question carefully.
"Stefi" wrote:
=COUNTIF($C$2:$C$7;A2)+SUMIF($C$2:$C$7;A2;$D$2:$D$ 7)
and fill down!
Regards,
Stefi
€˛TUNGANA KURMA RAJU€¯ ezt Ć*rta:
column -------------- column ------------ column
A (Name) B(code #) C(total persons working
under him)
1 JOHN 4 2 CARY 6
3 LARA 1 = ?
4 DAVID 0 = ?
5 LUCY 6
6 RAO 4
Range B1:B6 contains code numbers(in text format) represent range A1:A6
(persons) immediate Boss's row number.JOHN's row number is 1 and his code no
is 4(B1),that idicates he has one subordinate(LARA) and one immediate
boss(DAVID), WHEREAS LARA has no subordinates.
total persons working under JOHN = 1
total persons working under CARY= 0
total persons working under LARA= 0
total persons working under DAVID=5
total persons working under LUCY= 0
total persons working under RAO = 2
What formula will work to get the above desired results in column c ?
What formula will get names of all persons under any person in range A1:a6?
Help me, I am trying to solve this since 2 months.
|