Solved I want to assign value for name

April 2, 2019 at 21:06:15
Specs: Windows 7
Hi All,

I have team 3 members i want show their work status in graphical it will change dynamically
Work Points Staff
String 10 ABC
Search 20 XYZ
USA 8 DEF
YUP 3
IND 4 XYZ
AU 8 ABC

In Above example staff worked and total points they got

Staff Total Stories Total points
ABC 2 18
XYZ 2 27
DEF 1 8

Here i need :
In above example for "YUP" i didn't mention staff name
If i mention staff name as "DEF" automatically "1" should add in total stories so total stories =2
If i mention staff name as Xyz or abc automatically "1" should add in stories so total stories =3

here i need to get points also

Thanks & Regards
Satya



message edited by satya9


See More: I want to assign value for name

Report •

✔ Best Answer
April 3, 2019 at 11:04:59
Is there some reason that you continue to leave out the Column letters and Row numbers? It's really hard for us to create formulas for you if we don't know where your data is.

Just to move this along, I'll add my own Column letters and Row numbers. In the future, we may not be able to help you unless you do that yourself.

Input Data


      A                      B                   C
1   Work                  Points               Staff
2   String                  10                  ABC
3   Search                  20                  XYZ
4   USA                      8                  DEF
5   YUP                      3                  --
6   IND                      4                  XYZ
7   AU                       8                  ABC

Reporting Table


       A                     B                  C
8    Staff              Total Stories      Total points
9    ABC                     2                  18
10   XYZ                     2                  27
11   DEF                     1                   8

Based on my Column letters and Row numbers enter this in B9 and drag it down:

=COUNTIF($C$2:$C$7,A9)

Based on my Column letters and Row numbers enter this in C9 and drag it down:

=SUMIF($C$2:$C$7,A9,$B$2:$B$7)

BTW...How do you get 27 Total Points for XYZ? As far as I can tell, your Input data should result in 24 Total Points for XYZ.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03



#1
April 3, 2019 at 03:36:37
First, a posting tip:

Please click on the How-To link at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#2
April 3, 2019 at 06:36:44
Hi All,

I have team 3 members i want show their work status in graphical it will change dynamically

in preview table showing perfect

Team members
ABC
XYZ
DEF

Work assign to them
String
Search
USA and so on

Points
Based upon the complexity of work each work assigned some points
for example
If task is very complex point shows 20
if task is complex point shows 10
if task is easy point shows 3


Raw Data

Work	                 Points	                 Staff
String	                  10	                         ABC
Search	                  20                           XYZ
USA	                           8	                         DEF
YUP                           3	                           --
IND                            4	                        XYZ
AU	                          8	                        ABC

In Above example staff worked and total points they got

Reporting table

Staff        Total Stories              Total points
ABC                2	                       18
XYZ                2                              27
DEF                1                       	8

Here i need :
In above example for "YUP" i didn't mention staff name
If i mention staff name as "DEF" automatically "1" should add in total stories so
Total stories =2( in second table)
If i mention staff name as "XYZ " or "ABC" automatically "1" should add in Total stories so Total stories =3 ( in second table)

Based upon work assigned to team member automatically i need to get Total points
as shown in second table

For example

ABC and DEF worked on two tasks but total points are different

Here i am looking, Automatically story points should add based on work assign to them in second table

example
ABC work on two task as shown in first table, based on that automatically points should add in second table
if i assign one of task of "ABC" to other team "DEF "member in first table , automatically points should go down to ABC(second table) at the same time Total points of "DEF "should increase (second table)

Basically second table is for Reporting


Thanks & Regards
Satya


Report •

#3
April 3, 2019 at 08:00:50
I'm still confused by your data layout. I could take a guess at what your data looks like, but if I get it wrong, I'll have wasted my time (and yours) by coming up with a solution that won't fit your needs.

First, you did not include column letters or row numbers as shown in the instructions.

Second, in your second table, I see numbers under the word "Total" and numbers under the word "Stories". Is that correct?

Third, what do you mean by "here i need to get points also"?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •

Related Solutions

#4
April 3, 2019 at 11:04:59
✔ Best Answer
Is there some reason that you continue to leave out the Column letters and Row numbers? It's really hard for us to create formulas for you if we don't know where your data is.

Just to move this along, I'll add my own Column letters and Row numbers. In the future, we may not be able to help you unless you do that yourself.

Input Data


      A                      B                   C
1   Work                  Points               Staff
2   String                  10                  ABC
3   Search                  20                  XYZ
4   USA                      8                  DEF
5   YUP                      3                  --
6   IND                      4                  XYZ
7   AU                       8                  ABC

Reporting Table


       A                     B                  C
8    Staff              Total Stories      Total points
9    ABC                     2                  18
10   XYZ                     2                  27
11   DEF                     1                   8

Based on my Column letters and Row numbers enter this in B9 and drag it down:

=COUNTIF($C$2:$C$7,A9)

Based on my Column letters and Row numbers enter this in C9 and drag it down:

=SUMIF($C$2:$C$7,A9,$B$2:$B$7)

BTW...How do you get 27 Total Points for XYZ? As far as I can tell, your Input data should result in 24 Total Points for XYZ.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Report •

#5
April 3, 2019 at 11:49:51
Thanks you so much

Report •

Ask Question