|
sumif maybe?
lets try again.
Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra |
sumif maybe?
Stick to the one thread and stop wasting people's time by replicating
questions. -- __________________________________ HTH Bob "Esradekan" wrote in message ... lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra |
sumif maybe?
On Aug 28, 8:08*pm, "Bob Phillips" wrote:
Stick to the one thread and stop wasting people's time by replicating questions. -- __________________________________ HTH Bob "Esradekan" wrote in message ... lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. *Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra- Hide quoted text - - Show quoted text - Dont get uptight Bob, maybe if you had of answered my earlier post, I wouldnt of thought that i wasnt so clear with that post and wouldnt have decided to post again, trying to be clearer. I appreciate your efforts in answering posts to this newsgroup, I understand you probably dont have to, but Bob, I dont need 'abuse' either. I have been polite with you, please be so with me. Dont "tell" me, ask me. You get better results with sugar than you do with vinegar. I see you finally answered my post, I guess because you saw this one. Im still no further ahead with this and your right, your solution did not work. Still TIA, Esra |
sumif maybe?
I am not getting uptight, I am just telling you how to conduct yourself in a
sensible manner if you want us to continue to give free help, we are under no obligations to help, and it is up to you to conduct yourself in a manner that does not antagonise those that you seek help from. Multiple threads does not fit that description IMO. If you think I was being abusive, I think you must have led a very sheltered life. I was direct, but certainly not abusive. And check the times on the previous post, you will see that all of my posts in that thread are before your first post in this. So you clearly decided to ignore my comment and open a new thread for what reason I know not. I will now bow out, I wish you well in your search for a solution, but I will not be participating in seeking it any further. -- __________________________________ HTH Bob "Esradekan" wrote in message ... On Aug 28, 8:08 pm, "Bob Phillips" wrote: Stick to the one thread and stop wasting people's time by replicating questions. -- __________________________________ HTH Bob "Esradekan" wrote in message ... lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra- Hide quoted text - - Show quoted text - Dont get uptight Bob, maybe if you had of answered my earlier post, I wouldnt of thought that i wasnt so clear with that post and wouldnt have decided to post again, trying to be clearer. I appreciate your efforts in answering posts to this newsgroup, I understand you probably dont have to, but Bob, I dont need 'abuse' either. I have been polite with you, please be so with me. Dont "tell" me, ask me. You get better results with sugar than you do with vinegar. I see you finally answered my post, I guess because you saw this one. Im still no further ahead with this and your right, your solution did not work. Still TIA, Esra |
sumif maybe?
Firstly Bob, what does IMO mean?
Secondly, everybody must 'learn' how to post, wether its top or bottom, seems trivial to me but if thats your preference i will do so. Thirdly, I simply was just trying to explain myself a bit better, wasnt it your words "but I do not understand the deetails." Therefore I dont see the problem. Your comment to me was one of TELLING me, not asking me (therefore abusive in manner) which of course I would have done had the roles been reversed. How do you know if I know about ettiquette or not? Only fair. But thats OK Bob, I will take the blame for what went wrong - a simple case of misinterpretation of what you said. Guess it happens when we are a global society huh? Esra On Aug 29, 9:12*am, "Bob Phillips" wrote: I am not getting uptight, I am just telling you how to conduct yourself in a sensible manner if you want us to continue to give free help, we are under no obligations to help, and it is up to you to conduct yourself in a manner that does not antagonise those that you seek help from. Multiple threads does not fit that description IMO. If you think I was being abusive, I think you must have led a very sheltered life. I was direct, but certainly not abusive. And check the times on the previous post, you will see that all of my posts in that thread are before your first post in this. So you clearly decided to ignore my comment and open a new thread for what reason I know not. I will now bow out, I wish you well in your search for a solution, but I will not be participating in seeking it any further. -- __________________________________ HTH Bob "Esradekan" wrote in message ... On Aug 28, 8:08 pm, "Bob Phillips" wrote: Stick to the one thread and stop wasting people's time by replicating questions. -- __________________________________ HTH Bob "Esradekan" wrote in message .... lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra- Hide quoted text - - Show quoted text - Dont get uptight Bob, maybe if you had of answered my earlier post, I wouldnt of thought that i wasnt so clear with that post and wouldnt have decided to post again, trying to be clearer. I appreciate your efforts in answering posts to this newsgroup, I understand you probably dont have to, but Bob, I dont need 'abuse' either. *I have been polite with you, please be so with me. *Dont "tell" me, ask me. *You get better results with sugar than you do with vinegar. I see you finally answered my post, I guess because you saw this one. Im still no further ahead with this and your right, your solution did not work. Still TIA, Esra- Hide quoted text - - Show quoted text - |
sumif maybe?
IMO = In My Opinion. The thing with multiposting is that sometimes you spend a lot of time and effort to help someone with a complicated problem, you post it only to discover that the OP (original poster) has post the same question again where 2 other people have spend considerable effort and maybe time as well to come up with the same answer. I can tell you it doesn't feel good. You shouldn't post again unless you don't get any answer at all in maybe 24 hours. All people in these newsgroups/forums do it for free and are not in any way associated with Microsoft. Secondly by posting the same question twice you will screw up the indexing somewhat for the search engines that other people can use to find the answers. Since most of the regulars are using newsreaders your original post won't disappear the same way it does in a web forum. You are not the worst offender far from it, some people think it is a marvelous idea to put URGENT in the subject line and post the same question in multiple newsgroups/forums that really ticks me off. Anyway hope this help in your understanding of why some regulars (and Bob is certainly one of the most knowledgeable and frequent posters when it comes to answering questions) get somewhat irritable when people multipost. Here are some hints and tips done way back but still current. http://www.cpearson.com/Excel/newposte.htm -- Regards, Peo Sjoblom "Esradekan" wrote in message ... Firstly Bob, what does IMO mean? Secondly, everybody must 'learn' how to post, wether its top or bottom, seems trivial to me but if thats your preference i will do so. Thirdly, I simply was just trying to explain myself a bit better, wasnt it your words "but I do not understand the deetails." Therefore I dont see the problem. Your comment to me was one of TELLING me, not asking me (therefore abusive in manner) which of course I would have done had the roles been reversed. How do you know if I know about ettiquette or not? Only fair. But thats OK Bob, I will take the blame for what went wrong - a simple case of misinterpretation of what you said. Guess it happens when we are a global society huh? Esra On Aug 29, 9:12 am, "Bob Phillips" wrote: I am not getting uptight, I am just telling you how to conduct yourself in a sensible manner if you want us to continue to give free help, we are under no obligations to help, and it is up to you to conduct yourself in a manner that does not antagonise those that you seek help from. Multiple threads does not fit that description IMO. If you think I was being abusive, I think you must have led a very sheltered life. I was direct, but certainly not abusive. And check the times on the previous post, you will see that all of my posts in that thread are before your first post in this. So you clearly decided to ignore my comment and open a new thread for what reason I know not. I will now bow out, I wish you well in your search for a solution, but I will not be participating in seeking it any further. -- __________________________________ HTH Bob "Esradekan" wrote in message ... On Aug 28, 8:08 pm, "Bob Phillips" wrote: Stick to the one thread and stop wasting people's time by replicating questions. -- __________________________________ HTH Bob "Esradekan" wrote in message ... lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra- Hide quoted text - - Show quoted text - Dont get uptight Bob, maybe if you had of answered my earlier post, I wouldnt of thought that i wasnt so clear with that post and wouldnt have decided to post again, trying to be clearer. I appreciate your efforts in answering posts to this newsgroup, I understand you probably dont have to, but Bob, I dont need 'abuse' either. I have been polite with you, please be so with me. Dont "tell" me, ask me. You get better results with sugar than you do with vinegar. I see you finally answered my post, I guess because you saw this one. Im still no further ahead with this and your right, your solution did not work. Still TIA, Esra- Hide quoted text - - Show quoted text - |
sumif maybe?
Thank you, all I can say is "most informative",,,and of course I will
heed this. Esra On Aug 29, 10:07*am, "Peo Sjoblom" wrote: IMO = In My Opinion. The thing with multiposting is that sometimes you spend a lot of time and effort to help someone with a complicated problem, you post it only to discover that the OP (original poster) has post the same question again where 2 other people have spend considerable effort and maybe time as well to come up with the same answer. I can tell you it doesn't feel good. You shouldn't post again unless you don't get any answer at all in maybe 24 hours. All people in these newsgroups/forums do it for free and are not in any way associated with Microsoft. Secondly by posting the same question twice you will screw up the indexing somewhat for the search engines that other people can use to find the answers. Since most of the regulars are using newsreaders your original post won't disappear the same way it does in a web forum. You are not the worst offender far from it, some people think it is a marvelous idea to put URGENT in the subject line and post the same question in multiple newsgroups/forums that really ticks me off. Anyway hope this help in your understanding of why some regulars (and Bob is certainly one of the most knowledgeable and frequent posters when it comes to answering questions) get somewhat irritable when people multipost. Here are some hints and tips done way back but still current. http://www.cpearson.com/Excel/newposte.htm -- Regards, Peo Sjoblom "Esradekan" wrote in message ... Firstly Bob, what does IMO mean? Secondly, everybody must 'learn' how to post, wether its top or bottom, seems trivial to me but if thats your preference i will do so. *Thirdly, I simply was just trying to explain myself a bit better, wasnt it your words "but I do not understand the deetails." *Therefore I dont see the problem. *Your comment to me was one of TELLING me, not asking me (therefore abusive in manner) which of course I would have done had the roles been reversed. *How do you know if I know about ettiquette or not? *Only fair. But thats OK Bob, I will take the blame for what went wrong - a simple case of misinterpretation of what you said. *Guess it happens when we are a global society huh? Esra On Aug 29, 9:12 am, "Bob Phillips" wrote: I am not getting uptight, I am just telling you how to conduct yourself in a sensible manner if you want us to continue to give free help, we are under no obligations to help, and it is up to you to conduct yourself in a manner that does not antagonise those that you seek help from. Multiple threads does not fit that description IMO. If you think I was being abusive, I think you must have led a very sheltered life. I was direct, but certainly not abusive. And check the times on the previous post, you will see that all of my posts in that thread are before your first post in this. So you clearly decided to ignore my comment and open a new thread for what reason I know not. I will now bow out, I wish you well in your search for a solution, but I will not be participating in seeking it any further. -- __________________________________ HTH Bob "Esradekan" wrote in message .... On Aug 28, 8:08 pm, "Bob Phillips" wrote: Stick to the one thread and stop wasting people's time by replicating questions. -- __________________________________ HTH Bob "Esradekan" wrote in message .... lets try again. Column Headers are (B1:P1) Staff 1 Staff 2 etc A2:A27 is a date range (fortnightly dates range called "Date") B2:B27 are figures relevant to the dates for Staff 1, staff 2 (C2:C27) etc I need to find the total value of the figures for each month. I have January, February etc in C31:N21 (to December) and require the totals for each staff member for each month. Staff members listed B32:B61 Staff1 figures are named "Staff1", Staff2 are named "Staff2" etc. what formula can i use? TIA Esra- Hide quoted text - - Show quoted text - Dont get uptight Bob, maybe if you had of answered my earlier post, I wouldnt of thought that i wasnt so clear with that post and wouldnt have decided to post again, trying to be clearer. I appreciate your efforts in answering posts to this newsgroup, I understand you probably dont have to, but Bob, I dont need 'abuse' either. I have been polite with you, please be so with me. Dont "tell" me, ask me. You get better results with sugar than you do with vinegar. I see you finally answered my post, I guess because you saw this one. Im still no further ahead with this and your right, your solution did not work. Still TIA, Esra- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
sumif maybe? [OT]
Don Guillett wrote:
[much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV. |
sumif maybe? [OT]
On Aug 29, 3:11*pm, smartin wrote:
Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV. Writing from the right is natural for chinese people too Whats natural for one may not be for others. Just a thought. Esra |
sumif maybe? [OT]
Top-posting has been the widely accepted preference on the Excel newsgroups
for some time. http://www.cpearson.com/excel/newposte.htm http://www.mvps.org/dmcritchie/excel/posting.htm for two references. -- David Biddulph "smartin" wrote in message ... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV. |
sumif maybe? [OT]
If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... -- Don Guillett Microsoft MVP Excel SalesAid Software "smartin" wrote in message ... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV. |
sumif maybe? [OT]
But what about the thought that if you read the 'whole' of the posts
to see what has been happening - so to speak - its natural to read the original post first, at the top, and then following posts after that. But it doesnt matter, whatever you guys think is best I will do. I DO still need a solution for my original question and I think this thread is getting way off topic. Esra On Aug 30, 12:21*am, "Don Guillett" wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... -- Don Guillett Microsoft MVP Excel SalesAid Software "smartin" wrote in message ... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV.- Hide quoted |
sumif maybe? [OT]
You know something, I have learnt a thing or two here this time
around. I was relatively new at posting here, just for the odd thing now and again. I post using google and during the process of viewing the posts, I displayed them differently. NOW I can see the merits of top posting. It does make sense. I also never meant to **** anybody off and it wouild seem I have done that. I always treat people how they treat me. So if your one of the people I have ****ed off, I apologise. Hell I never even knew the subject line had been changed of the thread (OT). Im still learning and i guess I always will be learning. I do though, still need a simple formula. I have changed my worksheet around to be more 'user friendly', but the original problem still exists, cells I can change to suit. Im not very experienced like you guys in Excel, but I do have that knowledge to do that. I hope that someone can qustill help me. Again, TIA Esra On Aug 30, 9:44*am, Esradekan wrote: But what about the thought that if you read the 'whole' of the posts to see what has been happening - so to speak - its natural to read the original post first, at the top, and then following posts after that. But it doesnt matter, whatever you guys think is best I will do. *I DO still need a solution for my original question and I think this thread is getting way off topic. Esra On Aug 30, 12:21*am, "Don Guillett" wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... -- Don Guillett Microsoft MVP Excel SalesAid Software "smartin" wrote in message m... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV.- Hide qustill help me. Again, TIA Esra |
sumif maybe? [OT]
|
sumif maybe? [OT]
Yes and I emailed you the workbook, assumed you didnt get time to look
at it, because that was yesterday. I thank you for the offer. Esra TIA On Aug 30, 10:36*am, "Don Guillett" wrote: Let's see. As I recall, in an earlier post of mine I offered to take a look. IF..... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... You know something, I have learnt a thing or two here this time around. *I was relatively new at posting here, just for the odd thing now and again. *I post using google and during the process of viewing the posts, I displayed them differently. *NOW I can see the merits of top posting. *It does make sense. *I also never meant to **** anybody off and it wouild seem I have done that. *I always treat people how they treat me. *So if your one of the people I have ****ed off, I apologise. *Hell I never even knew the subject line had been changed of the thread (OT). *Im still learning and i guess I always will be learning. I do though, still need a simple formula. *I have changed my worksheet around to be more 'user friendly', but the original problem still exists, cells I can change to suit. *Im not very experienced like you guys in Excel, but I do have that knowledge to do that. *I hope that someone can qustill help me. Again, TIA Esra On Aug 30, 9:44 am, Esradekan wrote: But what about the thought that if you read the 'whole' of the posts to see what has been happening - so to speak - its natural to read the original post first, at the top, and then following posts after that. But it doesnt matter, whatever you guys think is best I will do. I DO still need a solution for my original question and I think this thread is getting way off topic. Esra On Aug 30, 12:21 am, "Don Guillett" wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... -- Don Guillett Microsoft MVP Excel SalesAid Software "smartin" wrote in message m... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV.- Hide qustill help me. Again, TIA Esra- Hide quoted text - - Show quoted text - |
sumif maybe? [OT]
|
sumif maybe? [OT]
Esradekan wrote:
On Aug 29, 3:11 pm, smartin wrote: Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV. Writing from the right is natural for chinese people too Whats natural for one may not be for others. Just a thought. Esra Esra, I'm not pointing this at you. Placing a new paragraph /below/ the existing one is the way we all write, with the exceptions that when writing on usenet or email many are compelled to write the new paragraph /above/ the old ones. Why is this? I think in rapid-fire electronic conversation top-posting works because anyone involved in the discussion easily remembers the context; they do not need to look through the history to understand what's going on. On the other hand, these conversations are being committed indefinitely. Someone may come across this conversation weeks or years later. If they read this message from the top-down, they will easily understand my position when they read these words. Had this conversation been all top-posted, they would have to read the story from the bottom-up. How natural is that? I'm not just talking about this post, of course. This is just me explaining why I prefer this over that, which admittedly is completely off-topic here and I should and will stop soon. What I am talking about in a larger sense is how we carry on conversations in this and similar groups: A question is asked. A clarification is requested. A clarification is provided. A tentative solution is proffered. Solution doesn't work. More information provided. Another solution is offered. Problem solved. Thanks! How would you prefer to follow this discourse? If it were top-posted all the way, at the top you see a solution with no problem. You would have to read through the messages from the bottom up just to understand the problem and the evolution of the solution. It's not natural. At least, that is my view. |
sumif maybe? [OT]
David Biddulph wrote:
Top-posting has been the widely accepted preference on the Excel newsgroups for some time. http://www.cpearson.com/excel/newposte.htm http://www.mvps.org/dmcritchie/excel/posting.htm for two references. The second reference is a parrot of the first. I have all respect for Chip Pearson, but I disagree with him on this point. |
sumif maybe? [OT]
Emailed again now, hopefully you will get it soon.
TY for your help. Esra On Aug 30, 11:16*am, "Don Guillett" wrote: Apparently it became lost in cyberland because I never saw it. Care to re-send and I'll take a look tomorrow. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... Yes and I emailed you the workbook, assumed you didnt get time to look at it, because that was yesterday. *I thank you for the offer. Esra TIA On Aug 30, 10:36 am, "Don Guillett" wrote: Let's see. As I recall, in an earlier post of mine I offered to take a look. IF..... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message .... You know something, I have learnt a thing or two here this time around. I was relatively new at posting here, just for the odd thing now and again. I post using google and during the process of viewing the posts, I displayed them differently. NOW I can see the merits of top posting. It does make sense. I also never meant to **** anybody off and it wouild seem I have done that. I always treat people how they treat me. So if your one of the people I have ****ed off, I apologise. Hell I never even knew the subject line had been changed of the thread (OT). Im still learning and i guess I always will be learning. I do though, still need a simple formula. I have changed my worksheet around to be more 'user friendly', but the original problem still exists, cells I can change to suit. Im not very experienced like you guys in Excel, but I do have that knowledge to do that. I hope that someone can qustill help me. Again, TIA Esra On Aug 30, 9:44 am, Esradekan wrote: But what about the thought that if you read the 'whole' of the posts to see what has been happening - so to speak - its natural to read the original post first, at the top, and then following posts after that. But it doesnt matter, whatever you guys think is best I will do. I DO still need a solution for my original question and I think this thread is getting way off topic. Esra On Aug 30, 12:21 am, "Don Guillett" wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... -- Don Guillett Microsoft MVP Excel SalesAid Software "smartin" wrote in message m... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV.- Hide qustill help me. Again, TIA Esra- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
sumif maybe? [OT]
Don Guillett wrote:
If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... Don, I disagree (see my dissertation response to Esra if you care), but it's cool. I do understand the bother factor, it just doesn't bother me so much. Enjoy your weekend! |
sumif maybe? [OT]
On Aug 30, 11:51*am, smartin wrote:
Don Guillett wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... Don, I disagree (see my dissertation response to Esra if you care), but it's cool. I do understand the bother factor, it just doesn't bother me so much. Enjoy your weekend! Can we end this (no solution) discussion now? Esra |
sumif maybe? [OT]
Sorry, posted wrong,,,,,
Can we end this (no solution) discussion now? Esra On Aug 30, 11:51*am, smartin wrote: Don Guillett wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... Don, I disagree (see my dissertation response to Esra if you care), but it's cool. I do understand the bother factor, it just doesn't bother me so much. Enjoy your weekend! |
sumif maybe? [OT]
Well, everyone can relax, I have sorted it out. Thanks so much to the people who helped me. Ended up redesigning the workbook, but was worth it. Esra On Aug 30, 2:05*pm, Esradekan wrote: Sorry, posted wrong,,,,, Can we end this (no solution) discussion now?Esra On Aug 30, 11:51*am, smartin wrote: Don Guillett wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... Don, I disagree (see my dissertation response toEsraif you care), but it's cool. I do understand the bother factor, it just doesn't bother me so much. Enjoy your weekend!- Hide quoted text - - Show quoted text - |
sumif maybe? [OT]
|
sumif maybe? [OT]
IMO (to use one of your guys terms), I thought I did, but not being
genius with excel, obviously not. It shouldnt of mattered where the cells were I would of thought, I could have adapted any formula to suit. All I did believe it or not, was put in an extra column, converting the dates to read the months, then the SUMIF formula worked. I named the column with the months "Date" (ie 14/4/2008 = April, 26/5/2008 = May) and used that as the criteria for the formula. But like so many things, obviously I am wrong, just like putting your email address in an email Don. But ty anyway. Esra On Aug 31, 12:08*am, "Don Guillett" wrote: I did NOT get your file but am happy to see that you are now happy. On future postings, please try to fully explain your problem the first time. A pet peeve of many here, including me... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... Emailed again now, hopefully you will get it soon. TY for your help. Esra On Aug 30, 11:16 am, "Don Guillett" wrote: Apparently it became lost in cyberland because I never saw it. Care to re-send and I'll take a look tomorrow. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... Yes and I emailed you the workbook, assumed you didnt get time to look at it, because that was yesterday. I thank you for the offer. Esra TIA On Aug 30, 10:36 am, "Don Guillett" wrote: Let's see. As I recall, in an earlier post of mine I offered to take a look. IF..... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message .... You know something, I have learnt a thing or two here this time around. I was relatively new at posting here, just for the odd thing now and again. I post using google and during the process of viewing the posts, I displayed them differently. NOW I can see the merits of top posting. It does make sense. I also never meant to **** anybody off and it wouild seem I have done that. I always treat people how they treat me. So if your one of the people I have ****ed off, I apologise. Hell I never even knew the subject line had been changed of the thread (OT). Im still learning and i guess I always will be learning. I do though, still need a simple formula. I have changed my worksheet around to be more 'user friendly', but the original problem still exists, cells I can change to suit. Im not very experienced like you guys in Excel, but I do have that knowledge to do that. I hope that someone can qustill help me. Again, TIA Esra On Aug 30, 9:44 am, Esradekan wrote: But what about the thought that if you read the 'whole' of the posts to see what has been happening - so to speak - its natural to read the original post first, at the top, and then following posts after that. |
sumif maybe? [OT]
I do not know how my email address became corrupted. Go back and look at my
ORIGINAL post and all you have to do is click on it. If you still want to send the file, you will not need a helper column. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... IMO (to use one of your guys terms), I thought I did, but not being genius with excel, obviously not. It shouldnt of mattered where the cells were I would of thought, I could have adapted any formula to suit. All I did believe it or not, was put in an extra column, converting the dates to read the months, then the SUMIF formula worked. I named the column with the months "Date" (ie 14/4/2008 = April, 26/5/2008 = May) and used that as the criteria for the formula. But like so many things, obviously I am wrong, just like putting your email address in an email Don. But ty anyway. Esra On Aug 31, 12:08 am, "Don Guillett" wrote: I did NOT get your file but am happy to see that you are now happy. On future postings, please try to fully explain your problem the first time. A pet peeve of many here, including me... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... Emailed again now, hopefully you will get it soon. TY for your help. Esra On Aug 30, 11:16 am, "Don Guillett" wrote: Apparently it became lost in cyberland because I never saw it. Care to re-send and I'll take a look tomorrow. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... Yes and I emailed you the workbook, assumed you didnt get time to look at it, because that was yesterday. I thank you for the offer. Esra TIA On Aug 30, 10:36 am, "Don Guillett" wrote: Let's see. As I recall, in an earlier post of mine I offered to take a look. IF..... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... You know something, I have learnt a thing or two here this time around. I was relatively new at posting here, just for the odd thing now and again. I post using google and during the process of viewing the posts, I displayed them differently. NOW I can see the merits of top posting. It does make sense. I also never meant to **** anybody off and it wouild seem I have done that. I always treat people how they treat me. So if your one of the people I have ****ed off, I apologise. Hell I never even knew the subject line had been changed of the thread (OT). Im still learning and i guess I always will be learning. I do though, still need a simple formula. I have changed my worksheet around to be more 'user friendly', but the original problem still exists, cells I can change to suit. Im not very experienced like you guys in Excel, but I do have that knowledge to do that. I hope that someone can qustill help me. Again, TIA Esra On Aug 30, 9:44 am, Esradekan wrote: But what about the thought that if you read the 'whole' of the posts to see what has been happening - so to speak - its natural to read the original post first, at the top, and then following posts after that. But it doesnt matter, whatever you guys think is best I will do. I DO still need a solution for my original question and I think this thread is getting way off topic. Esra On Aug 30, 12:21 am, "Don Guillett" wrote: If you think about it, it is NOT natural to have to page down to the bottom to read a post. With top posting it's right in front of you. Most here agree. Some don't.... -- Don Guillett Microsoft MVP Excel SalesAid Software "smartin" wrote in message m... Don Guillett wrote: [much snipped] Also, please top post. [OT] I usually refrain from participating in top- vs bottom-posting debacles, but I do not recall any mention of a "top posting rule" here. Or is that your personal preference? Both methods have merit. IME, in technical discussions the latter is preferred and more natural. YMMV.- Hide qustill help me. Again, TIA Esra- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
sumif maybe? [OT]
Don,
I think Esra mentioned in an earlier post that he was using Google Groups to view these posts - everyone's email address gets some degree of protection on GG, so that might be why he couldn't send the file to you. Pete On Aug 30, 11:04*pm, "Don Guillett" wrote: I do not know how my email address became corrupted. Go back and look at my ORIGINAL post and all you have to do is click on it. If you still want to send the file, you will not need a helper column. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message |
sumif maybe? [OT]
TY pete, I knew I wasnt losing my marbles totally.
I didnt expect anyone to use a number in their email address either. My old mother told me years and years ago, do not assume, it makes an ASS out of U and ME. Guess I shouldnt have assumed with email addresses. Esra On Aug 31, 12:26*pm, Pete_UK wrote: Don, I thinkEsramentioned in an earlier post that he was using Google Groups to view these posts - everyone's email address gets some degree of protection on GG, so that might be why he couldn't send the file to you. Pete On Aug 30, 11:04*pm, "Don Guillett" wrote: I do not know how my email address became corrupted. Go back and look at my ORIGINAL post and all you have to do is click on it. If you still want to send the file, you will not need a helper column. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message- Hide quoted text - - Show quoted text - |
sumif maybe? [OT]
"David Biddulph" <groups [at] biddulph.org.uk wrote...
Top-posting has been the widely accepted preference on the Excel newsgroups for some time. http://www.cpearson.com/excel/newposte.htm .... And from that referenced article: '10 If you're following up to a previous post, you don't need to include everything. Snip out what's not relevant. But do include what is relevant. Some people may have missed the original post.' Note the part about snipping. If top-posters EVER snipped ANYTHING, it's news to me. But top-posters are the kind of people who are choosy about which rules to follow. Those that support their innate laziness are just fine. Other rules which might require effort and/or thought are for other people. Top posting may be preferred by most respondents, but only because most respondents use Outlook Express or web portals that default to top posting. It'd take a little work to delete the entire preceding thread, it'd take a bit more work ONCE to disable automatic quoting, and it'd take some thought to snip portions of the preceding thread. It seems such little effort and/or little thought it beyond the capacity or incliniation of top-posters. If you're going to top-post, why quote at all? There's always Google for the preceding thread. If you quote, then you should do so for the context it provides, and the only way it provides USEFUL context is if the context PRECEDES the response. |
sumif maybe? [OT]
I didnt expect anyone to use a number in their email address either.
I didn't either but it seems that there was already a dguillett so TW assigned the 1...... -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message ... TY pete, I knew I wasnt losing my marbles totally. I didnt expect anyone to use a number in their email address either. My old mother told me years and years ago, do not assume, it makes an ASS out of U and ME. Guess I shouldnt have assumed with email addresses. Esra On Aug 31, 12:26 pm, Pete_UK wrote: Don, I thinkEsramentioned in an earlier post that he was using Google Groups to view these posts - everyone's email address gets some degree of protection on GG, so that might be why he couldn't send the file to you. Pete On Aug 30, 11:04 pm, "Don Guillett" wrote: I do not know how my email address became corrupted. Go back and look at my ORIGINAL post and all you have to do is click on it. If you still want to send the file, you will not need a helper column. -- Don Guillett Microsoft MVP Excel SalesAid Software "Esradekan" wrote in message- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 07:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com