sumif maybe?

S

smartin

Don said:
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!
 
E

Esradekan

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
 
E

Esradekan

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
 
D

Don Guillett

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
(e-mail address removed)
Emailed again now, hopefully you will get it soon.

TY for your help.

Esra



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

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

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
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 piss 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 pissed 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
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
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
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 qustill help me.
Again, TIA
Esra- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -
 
E

Esradekan

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


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

Emailed again now, hopefully you will get it soon.

TY for your help.

Esra

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
(e-mail address removed)"Esradekan" <[email protected]> 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.

On Aug 30,
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
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 piss 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 pissed 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
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
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
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 qustill help me.
Again, TIA
Esra- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -
 
D

Don Guillett

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.
(e-mail address removed)

If you still want to send the file, you will not need a helper column.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
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


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

Emailed again now, hopefully you will get it soon.

TY for your help.

Esra

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
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.

On Aug 30,
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
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 piss 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 pissed 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
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" <[email protected]>
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
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 qustill help me.
Again, TIA
Esra- Hide quoted text -
- Show quoted text -- Hide quoted text -
- Show quoted text -- Hide quoted text -

- Show quoted text -
 
P

Pete_UK

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
 
E

Esradekan

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
 
H

Harlan Grove

David Biddulph said:
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.
 
D

Don Guillett

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
(e-mail address removed)
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top