Summing one column based on date in another column
I desperately need help here. I have a spreadsheet that has sales price in
one column and the date in another column. It will only add if the date is
the month only i.e., January vs January 1, 2005. I need it to add by month
based on all days within the month because that column has to have the actual
date not just the month.
For this example I'll assume date is in column A and amount is in column B:
If you're just interested in a specific month (january) you could use this:
Or, if you want to easily be able to change the month being...Empty cells , sum of it from weekday's
Hello, i have a weekly table monday-sunday (B, C, D and so on) for each week
of the year, persons are in A2, A3 A4 and so on, if a person is free on one
day of the week the cell is empty, now i like to have a new table wich counts
all the empty cells of a person on monday, all of them on wednesday and so
on, so that i can see over a whole year, how many times someone is free on
monday and so on.
please can anyone help me ?, best regards, Gerard
You have nicely described one week's data:
name of first person in A2; and a x (or other entry) in B2 if not free
Monday, in C2 if not free...Automate users creation.
Is there a way to automate users creation using .net?
> Is there a way to automate users creation using .net?
> Thanks, Landon
...Missing Results in Advanced Find: Calendar
When searching for appointments using advanced find, not
all results appear. I'm using Outlook 2002. Is there a fix
for this that Office Update does not provide?
Thanks for all help!!
what items are missing?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
V...Multilanguage User Interface
We've a crm customer with branches in different languages in the same
country - german/french.
According Microsoft the crm multilanguage user interface will be read for
version 3.0 - does somebody know if there is some possibilty or an ISV
Solution available sooner?
thks a lot!
I'm also looking for a CRM 1.2 MUI...anybody knows something about at? Maybe
some third party module?
> Hi all
> We've a crm customer with branches in different languages in the same
> country - german/french.
> According Microsoft the crm multilanguag...disallow outbound smtp for set of users
Does any one how to resolve this question in an exchange 2003 org?
1. on a excahnge 2003 org you have a group of users that need to b
able to send internal mail and external (internet) mail.
2. on the same exchange 2003 org you have a group of users that yo
only want to allow to send messages internal. By no means allo
messages to the internet.
I was told the solution to stop the outbound mail to the internet wa
to create a receipent policy with a smtp address of non-interne
registered / non-resolvable name (something like testthis.com). I kne
ahead of time this wasnt the solution ...Exchange 2003 : User rights issue.
We just found out that other user can view other user's folder without the
need to login to the other user's logon. In other words, User A can view
User B folder from Outlook without the need to login to User B account. This
seems a security issue. I notice that under the "Mailbox Rights" for all the
users, "Everyone" have "Read permission".
How do disallow this without going to each of the user's mailbox and change
the rights ? Is the "Mailbox Rights" (under the Exchange Advanced tab)
having the same user rights as the &quo...some users cant receive mail from certain domains
I have server03 sp1 and exchange03 sp2 and everything seemed to be
working well until it came to my attention that some mail was not being
received by some users.
What's really strange is that in all cases my account (or any new
account I create) can receive mail from the domains in question. Only
existing user accounts are having problems.
Mine is the admin account but I have tryed elevating existing users to
admin and it makes no difference. Policies are the same for everyone.
All users can send mail to the domains in question but only I receive a
Relpys eventually get an "u...CPU/Ram Usage by mailbox/user/connection
There MUST be a way in Exchange to get the following information:
How can I tell what mailbox/user/connection is generating the load on our
I can't say that I've ever seen such a perf counter.
Windows Server MVP
"Rob" <Rob@discussions.microsoft.com> wrote in message
> There MUST be a way in Exchange to get the following information:
> How can I tell what mailbox/user/connection is generating the...Running as a SPANISH user acts as thought the Control key is alwys down.
Our MFC-based software is such that a user can set it's preferred
language to one of a number of Languages, including Spanish. When
Spanish user logs into our system, it means nothing else than to
perform all the string lookups in another table, besides english. Our
strings don't come from Resource files, but rather from a Database
Other than that - everything is English - the OS, the keyboard, etc -
it's just that we're displaying spanish text and characters.
Here's the problem - When typing into an MFC-based edit box, the keys
behave as though the Control Key is ...How to find number of emails sent by a user in a day?
I would like to create run some statistics on the usage patterns. Is
there a way to compute the number of emails send by each user in a day?
We are running Exchange Server 2003 SP2.
Thank you in advance for your help.
You'd need 3rd party reporting tools like Prodomag, Quest MessageStats, et
"Pradeep" <email@example.com> wrote in message
> I woul...Outlook Web Access users
Anyone know of any tools that will allow exporting
Contacts out of Outlook Web access ? We have 1200 users
who have only Web Access as their E-mail client.
The only way remote users can export Exchange contacts
would be via Activesync or something of that nature that I
know about. Does anyone know of any other method or any
third party tools that would allow that capability ?
Any help in this matter would be most appreciated.
Director of MIS
Sibcy Cline Inc.
...Multiple user names at one bank or brokerage
I have 3 accounts at one bank. I have 3 corresponding accounts set up in MS
Money 2007. One of them is setup for online banking while the other two are
not. I now want to set the other two up for online banking but I can't find
a way to specify the unique login info for each of the other two accounts.
...Disable OWA By User
Without getting into a discussion of Certifictates, In A Server2003/EXCH2003
can you diable OWA by user?
"Hell, I would Piss on a Spark Plug if it would make the Darn Thing Work"
Aparently, but I have never tried it. Open the user account in Active
Directory Users and Computer (exchange integrated version of course) and
select the Exchange Features tab. There is an option to enable or disable
Outlook Web Access there.
"James Stoddard" wrote:
> Without getting into a discussion of Certifictates, In A Server2003/EXCH2003
> can you diable O...Please help for getting current user name
Please help me
advance thanksfor help
I recently published an article about that. Look at
Michael H�hne, Microsoft Dynamics CRM MVP
Custom Lookup Dialog: http://www.stunnware.com/crm2/?area=customLookup
"sujith" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:817B67E5-76F4-44BB-AF10-F74630A5AA...combobox after change but user hits cancel to message box
the code below is used to save some data when a user changes months on a
combobox. The code prompts the user to see if he/she wants to save the
estimates with a Yes, No, Cancel.
yes and no cases work as expected but when the user clicks cancel, the code
exits out as expected but the combox box value is now set to the new month
the user selected. I would like it to be set back to the month they had in
the combox before the changed it.
how can I do modify the code to do that or is there a better way to do this?
Private Sub cboMonth_Change()
Dim myCheck As Integ...Sum Function (was summing 13 cells to the left)
Trying to compose a formula that will only sum 13 cells to the left (13 months of data). When columns are added, I still only want to sum thirteens months of data. Can this be done without constanty changing my formulas? Make sense
see my reply to your old post
Neil S. wrote:
> Trying to compose a formula that will only sum 13 cells to the left
> (13 months of data). When columns are added, I still only want to
> sum thirteens months of data. Can this be done without constanty
> changing my formulas? Make sense? ...How can I create a folder under user's Inbox for all domain users
Is there any approach to create a folder under Outlook 2k's Inbox for all my
domain users in Exchange server-end (Exchange 2k3)? or any tools/scripts to
do this? And how can I set a Server-end rules for all the uses to deliver
some specific email to this folder?
Thans for your inputs.
...Sum data under special condition
I have a main and detail subform. In the subform I had a Check field (Yes/No
field) from the under laying table. I am having a problem of putting a
sum(amount) on the main form for only item that has a check in the Yes/No
Could someone advice?
I have Access 2003 on XP box.
A Yes/No field has a numeric value of zero when it is "No", and -1 when it
is "Yes". So, to achieve what you want, simply multiply the amount by the
Yes/No field, and by -1 e.g.
Sum(amount * yesnofield * -1)
"SF" <email@example.com> wrote in message
news:u9...Format changes when another user opens presentation
why do fonts change size when another user opens a shared presentation. Font
size overflows the text box, the text is either too big or too small and
unwraps so it goes off the slide, but when I open on my system, it's fine!?
On 12/15/09 9:15 AM, in article
> why do fonts change size when another user opens a shared presentation. Font
> size overflows the text box, the text is either too big or too small and
> unwraps so it goes off the slide, but...Can I delete messages from users that not logged on for x months ?
On Exch2003, if I have users that never logged on for the last 6 months, can
I make Exchange delete old messages from the respective mailbox
Not without some very creative scripting.
Marlon Brown wrote:
> On Exch2003, if I have users that never logged on for the last 6 months, can
> I make Exchange delete old messages from the respective mailbox
> automatically ?
Run the Mailbox cleanup agent
"Marlon Brown" <firstname.lastname@example.org> wrote in message
> On Exch2003, if I have users that never logg...sum in excel
I am trying to do a summary of hundreds of items which names start
with "ENG" (there are more categories), what I would like to have is a
summary of clumn E for items in column A that start with "ENG".
Look in the help index for SUMIF and incorporate a wildcard *eng
Microsoft MVP Excel
"fernango" <email@example.com> wrote in message
>I am ...How do I sum a formula and paste it in 7 cell increments?
I have two worksheets I'm working with. One of them is a running total of
cash for each day of the month. The second worksheet shows only the weekly
totals which come from the sum of 7 days from the first worksheet. I want to
know if its possible to copy the first week sum(A1:A7) and use some type of
formula to then copy the formula down in 7 day increments and not have to do
this manually. So the second entry would be sum(A8:A15), then sum(A16:A23),
Is this possible?
Copy down with the fill handle (the l...Help with this macro script on single results.
I put a request out a few days ago and I am attaching the macro script as
well so you can see where I am up to.
The problem is, if there is only one result returned for a particular staff
member, the script falls with a variable object error.
If there is more than 1 record, the script works fine. It just falls where
a single record is returned.
I am attaching the original message I sent as well as the script. PLease
note that Mike, the guy that helped me immensley witht his, has also doen a
few other things like auto summing which you will see in the script but not
...How To Scan that User Clicked End Process from an application
Is there a way to get that User Pressed End Process from the Task
Manager as VC++ do during debug mode.