sumif maybe?

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.

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.

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

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

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

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 -

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 -

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.

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.

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 -