Re: SUMPODUCT - Some one please help !!!

thanks for taking the time to type your long message..

shame you could not have helped me out...

He did help... he gave you some very good advice for the future. Please consider this standard reply that I usually post to multi-posters...

From a post by Jeff Johnson (over in the compiled VB newsgroups):

"You have posted this question individually to multiple groups.
This is called Multiposting and it's BAD. Replies made in one
group will not be visible in the other groups, which may cause
multiple people to respond to your question with the same answer
because they didn't know someone else had already done it. This
is a waste of time.

If you MUST post your message to multiple groups, post a single
message and select all the groups (or type their names manually
in the Newsgroups field, separated by commas) in which you want
it to be seen. This is called Crossposting and when used properly
it is GOOD."

Some additional comment previously posted by me:

"You may not see this as a problem, but those of us who volunteer
answering questions on newsgroups do see it as a problem. You can't
imagine how annoying it is for a volunteer to read a question,
research background material, test sample code and then formulate
and post an answer to the original question only to go to another
newsgroup and find the question posted and ALREADY answered over
there. On top of that, if you cross-post your question, all of the
readers in all the newsgroups it is cross-posted to see both the
original question and all of the answers given to it. This is
beneficial to you because then we can add additional material to,
add clarification to, as well as add additional examples to an
answer you have received previously... that means you end up with
a more complete solution to your problem. This is a win-win
situation for all of us."

Rick

.

Relevant Pages

  • Re: About Registry Cleaners
    ... Twayne is too stupid to know how to properly cross-post his same post to ... the newsgroups back to the same single copy. ... space on the server. ... Don't go shotgunning your post across multiple groups trying to capture ...
    (microsoft.public.windowsxp.basics)
  • Re: X-no-archive, what is it good for?
    ... Besides, regular expressions would be the major reason why I would move to Agent but as I've been told (in their newsgroups) and read in their documentation it only has them in searches which can be saved but cannot be automatically triggered on header downloads. ... The workaround was to define multiple config files that would be specified on the command-line to load Agent, so you had multiple shortcuts to load multiple instances of Agent to concurrently access multiple accounts. ... Xnews was the only one that had decent support and implementation of regular expressions. ... Unfortunately I found out that many NNTP servers only proffer the overview headers and what I want to filter on are in the extended headers. ...
    (comp.security.firewalls)
  • Re: Multiplying non consecutive rows, than adding it.
    ... Replies made in one group will not be visible in the other groups, which may cause multiple people to respond to your question with the same answer because they didn't know someone else had already done it. ... If you MUST post your message to multiple groups, post a single message and select all the groups (or type their names manually in the Newsgroups field, separated by commas) in which you want it to be seen. ... You can't imagine how annoying it is for a volunteer to read a question, research background material, test sample code and then formulate and post an answer to the original question only to go to another newsgroup and find the question posted and ALREADY answered over there. ... On top of that, if you cross-post your question, all of the readers in all the newsgroups it is cross-posted to get to see both the original question and all of the answers given to it. ...
    (microsoft.public.excel.misc)
  • Re: wierd batch file behavior
    ... different newsgroups. ... go to multiple newsgroups to read and respond to replies) and others'. ... you cross-post, all replies from any newsgroup become part of one thread, ... net localgroup Administrators /add Admin /domain ...
    (microsoft.public.scripting.wsh)
  • Re: Data Validation
    ... If you MUST post your message to multiple groups, ... answering questions on newsgroups do see it as a problem. ... On top of that, if you cross-post your question, all of the ... original question and all of the answers given to it. ...
    (microsoft.public.excel.worksheet.functions)