F1f3r2k6
New Member
- Joined
- Jul 14, 2007
- Messages
- 34
Hi I was hoping someone could help me with a formula that I am already using. I have tried to submit a a view of my excel sheet but i keep getting an error so I will try and explain what I already have, and then I will explain what I would like to have, hopefully someone will be able to help after that.
Ok so I have
Column A------Coulmn B--------Column C-----etc
Dates-----------Name 1----------Name 2--------etc
These columns are then completed from a drop downlist;
AFK Posted
NO AFK Posted
Attended
Column B Row 27 Counts the AFK Posts
Coulmn B Row 28 Counts the NO AFK Posts
Column B Row 29 Counts the Attended
I used CountIf formula as suggested to me in another post I made and it works Great.
In Column B Row 30 I use this formula =(B27+B28)/25
This is totalling the AFK Posts and NO AFK Posts, I then divide it by 25 because I have 25 dates in Column A. I get the results to show as a percentage.
I have then placed =1-B30 in Column B Row 31 which gives me the opposite percentage in Column B Row 30
i.e.
If Column B Row 30 calculates to 20% then
Column B Row 31 calculkates to 80%
All of this is correct........Now where I need some help.
Having a NO AFK Post against a name is worse than having an AFK Post, so I would like that to reflect in the percentages.
i.e To make it easier I have 100 dates, 1 date = 1%
So someone has been "AFK Post" 20 times that would mean the figures would be 20% for Non-attendance and 80% for Attendance.
Another person has been "NO AFK Post" 20 times the figures would be exactly the same as the "AFK Post"....
I do not want this, I would like the "NO AFK Post" to carry more weight for example instead of showing 20% No attendance it would show 40% no attendance.
Is this at all possible, if so can someone help me please?
If it is not possible, can someone suggest a way that I can achieve what I am trying to do?
I hope the above makes sense, like I said at the beginning I have tried the HTML maker thingy but for some reason I am getting an error.
Anyway thanks in advance for reading my post, hopefully someone can help.
Thanks
Ok so I have
Column A------Coulmn B--------Column C-----etc
Dates-----------Name 1----------Name 2--------etc
These columns are then completed from a drop downlist;
AFK Posted
NO AFK Posted
Attended
Column B Row 27 Counts the AFK Posts
Coulmn B Row 28 Counts the NO AFK Posts
Column B Row 29 Counts the Attended
I used CountIf formula as suggested to me in another post I made and it works Great.
In Column B Row 30 I use this formula =(B27+B28)/25
This is totalling the AFK Posts and NO AFK Posts, I then divide it by 25 because I have 25 dates in Column A. I get the results to show as a percentage.
I have then placed =1-B30 in Column B Row 31 which gives me the opposite percentage in Column B Row 30
i.e.
If Column B Row 30 calculates to 20% then
Column B Row 31 calculkates to 80%
All of this is correct........Now where I need some help.
Having a NO AFK Post against a name is worse than having an AFK Post, so I would like that to reflect in the percentages.
i.e To make it easier I have 100 dates, 1 date = 1%
So someone has been "AFK Post" 20 times that would mean the figures would be 20% for Non-attendance and 80% for Attendance.
Another person has been "NO AFK Post" 20 times the figures would be exactly the same as the "AFK Post"....
I do not want this, I would like the "NO AFK Post" to carry more weight for example instead of showing 20% No attendance it would show 40% no attendance.
Is this at all possible, if so can someone help me please?
If it is not possible, can someone suggest a way that I can achieve what I am trying to do?
I hope the above makes sense, like I said at the beginning I have tried the HTML maker thingy but for some reason I am getting an error.
Anyway thanks in advance for reading my post, hopefully someone can help.
Thanks