Hi All.
I have a data set as below
Q1 Q2
WE1 4 4
WE1 4 5
WE1 3 4
WE2 4 3
WE2 3 2
WE2 2 1
WE3 1 4
WE3 4 5
WE3 5 4
I need to come up with a weekly chart that shows percentage of scores for each week regardless of the question.
that means , say for week 1, ill need to count how many scored 4, how many scored 5, etc. and then divide by total responses...
ex. week 1 has 4 scores = 4 divide by 6 (total response)
Hope i could get a head around what best formula to use to generate this.
Thanks
with your data in A1:C10, use....
=SUMPRODUCT((A2:A10="WE1")*(B2:C10=4))
as an alternative, you add "WE?" and 1 etc in other cells and then reference them in the formula, instead of hard coding. that way, you can create a table that does all the cals for you...just be sure to check your table references when you copy, maybe absolute ($) them<
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks