Multiple Countif Sums
I have 2 calculation to find out, one that finds all cells in K:K that have a
time equal to or less than 4:00:00 (4 o clock) and the other that finds the
ones that are equal to or over 4:00:01. Obviously that is easy enough but I
only want to include the ones that have a 1 in the corresponding G:G column.
I have has a search around on here and gone through several sums using
countif, sumproduct, count(if but none are giving out the correct figures.
Can anyone assist?
Thank you in advance
But SUMPRODUCT does not accept whole columns frerences like G:G.
If you want tu su...Multiple SMTP Addresses
We've had trouble getting e-mail to route between our 2 Exchange
servers internally. Each server is in its own administrative group and
installed the routing connector for each group.
Recently, we've added a new alias for mail. The external MX record has
been added, and the A record will point to the external address in a
new location (old location will retain external SMTP mail for a
different SMTP address).
My question is: how do I create a recipient policy to allow for the
new SMTP alias (as primary) separate from the policy used for the
other location? (They have a differ...same options for multiple charts
I have monthly pie charts which are in separate sheets that are updated at
the end of the month. I would like each pie slice to maintain consistency
with color throughout the months. How do I go about having the same options
for every single pie chart I create without having to invidiviually go in and
change each chart every month?
I also have a YTD pie chart which I would like to be updated every time I
add data to the new month's chart. Is there a way this can be automatically
PLEASE HELP! Thanks!!
What kind of options? What changes about the data or chart that cause...Replacing a node
Is there a way to replace a node and it's children? I tried using the
ReplaceChild method but that seems to only replace the first child only!!
Ed A wrote:
> Is there a way to replace a node and it's children? I tried using the
> ReplaceChild method but that seems to only replace the first child only!!
will replace node with newNode.
If you still have problems then provide more details on what you have tried.
Martin Honnen --- MVP XML
This is what I've tried:
I am trying to create queries to sort church membership data according to any
number of ministry groups (out of a possible 56) they volunteer for. My goal
is to create a report for each of the Ministry's with name and contact
information. I have some questions with corresponding database description
information that will hopefully enable an expert to point me in the right
(1) I am at the query step and am looking for a way to link up the ministry
with the corresponding FName. I have entered a ministry name in the criteria
cells (e.g., "Choir") for all 28 c...macro to Find Replace in Excel
I need to find double quotes in an excel file (could be a selectoin of
rows) and replace them with nothing ( yeah just want to delete them)
The built in Excel function to Find and Replace all gives me error
"formula too long"
Can someone please write me a small macro code
I just tried with Find and Replace
Replace All " with nothing entered removes all " from sheet/range
Replace All "" with nothing entered removes all "" from sheet/range, but
entries like " or " " remain unchanged.
"Nurddin&quo...Problem using Find and Replace ,B with ,C within an Excel Formula
I am trying to replace ,B with ,C in the following formula and get an
When I do a find and replace of ,B with ,C Excel replaces the :B with :C
instead of replacing ,B with ,C . See the result below after the fin...Multiple Modeless Dialogs
I have multiple modeless dialogs as children in a CView window. I wish to
arrange these in the view, but can't quite figure out how to get the size of
each one and convert this into the sizes used in the parent dialog.
If anyone could point me in the right direction it would be greatly
Thanks in advance,
What does this mean? You can get the size using
GetWindowRect/GetClientRect etc. But I dont follow what you are going
to do with moving them within a view etc.
> I have multiple modeless dialogs as ch...dynamic reference to data in multiple closed workbooks
Hi, I'm working with a job list (generated out of a different program) and
data in associated closed workbooks. For example, the job list has names like
HD-100311-TA031110, SHT-100312, 032110Mag and I can generate a list of these
jobs along with other information I need. For every job there's an associated
workbook and, without opening the workbook I want to pull, for example,
'[\\de-mt1\clients\QC Reports\Proofs Adjusted\HD-100311-TA031110 proof
adjusted.xls]'Upload'!A$2 where the only information that will change is the
job name. I'm novice enough not to...Multiple list boxes
In my form design, I have 3 list boxes in a form. List box 1 is created from
a query, and is unbound. List box 2 is set to get whatever I selected from
box 1. These two boxes work, without problems. Now I run into troubles trying
to get list box 3 to get information from what I selected from list box 2.
The criteria for list box 3 is [forms]![formname]![listbox2]...please help.
What happens with List3? Do you get too many records, too few, wrong
Please indicate sample values, and your filtering fields and criteria
from List1 through List3.
...Overtime Calculation based on multiple hourly pay codes.
The system presently is just not designed to calculate overtime based on
multiple hourly pay codes.
If you enter 20 hours in one hourly paycode and 25 hours worked in another,
these would all need to be entered for the same hourly pay code in order for
5 overtime hours to auto-calculate.
The system should have the ability to check all the hourly paycodes for a
given pay-period and then automatically calculate overtime if need be.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this s...Deleting rows based on IF statement
How can I delete a row based on an IF statement?
For example, if cell h2=C and if cell k2 = zero, then delete that row.
I would apply Data|Filter|Autofilter to the whole range.
Then I'd filter on column H to show "C"
Then I'd filter on column K to show 0
Then delete those visible rows
Then Data|Filter|show all
to see everything left.
> How can I delete a row based on an IF statement?
> For example, if cell h2=C and if cell k2 = zero, then delete that row.
> Thank you.
...Multiple Interest Rates on the Same Credit Card Account
Has anyone figured out how to differentiate between
different interest rates (i.e. Purchases at 10%, Cash
Advances at 20%) in Microsoft Money 2002?
Help! The debt reduction planner is not all that helpful
with out this key piece of information!!
...Multiple OL2000 processes running, none visible
I've seen this question asked in Usenet archives, but I haven't found a KB
article or any definitive explanation on this.
Here's the problem I have with a couple of users running Outlook 2000 on
Windows 2000 Professional. Both are up-to-date on patches.
They both launch Outlook from an icon in the Quick Launch folder; while
troubleshooting this problem, I changed that icon to be a "regular"
shortcut -- in other words, OL is launched with no command line parameters.
Sometimes, they will click on the icon and "nothing happens." There is no
"task" di...Move multiple folders
Is there a way to move several folders (within the folder
list) at once?
> Is there a way to move several folders (within the folder
> list) at once?
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace.com is the domain.
I don't speak for Smiths, and Smiths doesn't speak for me.
...Link contact to multiple accounts
In MSCRM a contact can have only one account.
How can I link contact to multiple accounts ? I have a contact person
1. VP of Eng of company A
2. Board of director of company B
3. Board of director of company C
How do I store this information ? How do I customize ? Do I create a
relation ? Any thoughts ?
You could use the Powerrelate feature of Powertrak Core from Axonom, Inc.
This is an ISV MS CRM add-on that does exactly that, and more. See
"Arch" <email@example.com> wrote in message
news:firstname.lastname@example.org...Multiple distribution points in config.xml
Anyone have an example of a config.xml file for Office 2007 with multiple
distribution points? I currently have Office 2007 deployed but with only one
network location and I would like to add additional ones for backup via a
config.xml but I haven't found one example or a single bit of documentation
on multiple points via a config.xml.
Hi all, new Outlook 2003 user here with a problem. Here's the issue: I have 2 email accounts in my life, a hotmail account, and my work email account. I've set them both up as seperate email accounts in Outlook, and both work just fine. But here's the rub: In order to connect to my work email account (which is set-up as an exchange server email account) I have to first connect using VPN software on my PC. I only really want to check my work email once or twice a month, so therefore I don't want to fire-up my VPN software every time I open Outlook. My hotmail, on the other...Changing dates across multiple worksheets
I have a workbook that contains 18 sheets. Is it possible to change the date
on sheet 1 and have it change on the other 17 sheets, even though the sheets
contains two different date formats, 5/25, and 5/25/10, and all of the sheets
are different than sheet 1? I’m using Excel 2007.
Link each of the date cells on 17 sheets back to the main sheet where you
will change the date.
=Main!A1 where A1 is the changing date.
Each sheet formatted to your choice.
Gord Dibben MS Excel MVP
On Tue, 25 May 2010 08:38:01 -0700, Malcolm
<Malcolm@discussions.mic...multiple copies of contacts after sync, and only one category is showing in address book
I have a user who after synching contacts with his axim has 3 copies of
each - how can I remove the unecessary ones? Also he has his contacts
separated into categories and only one shows in the address book - how
can I get them all to show?
thanks in advance for your help.
he is using outlook 2003
email@example.com <firstname.lastname@example.org> wrote:
> I have a user who after synching contacts with his axim has 3 copies
> of each - how can I remove the unecessary ones?
Select the duplicates and click Delete.
> Also he has his contacts separated...Data validation for Multiple columns
I am creating a spreadsheet which will have data entry from different
I want to give the validation in such a way that a combination of
values in 2 columns do not occur more than once.
in above example the combination 2 and a is recurring. it should be
restricted by validation while entering the data itself.
can anybody please help
sorry for bothering you all
but i got a solution on other group
here is link for others reference
My client sends one email and recipients receive multiple copies.Has =
anyone seen this before and can shed some light.
>My client sends one email and recipients receive
multiple copies.Has anyone seen this before and can shed
>having the same trouble with 2003, are you using a
remote pop3 server?
>>My client sends one email and recipients receive
>multiple copies.Has anyone seen this before and can shed
>>having the sam...multiple database
I have 2 access database, both with a table called Score (that has names and
grades as fields).
Can I query from a third access database to have the average of grades from
the 2 access database?
YES, you can.
Oh, you want a solution. Does the third database have links to the score
tables in the other 2 databases?
SELECT [Name], [Grade]
SELECT [Name], [Grade]
SELECT [Name], Avg([Grade])
GROUP BY [Name]
Now with that UNION query as the source you can build a totals query. If
the third database d...calculating time with IF statement
I have the following:
A1 is formated as time = 7:30 AM
A2 is formated as time = 6:00 PM
A3 is formated as time and contains =sum(A2 - A1) and gives 10:30
That part I've got down.
Now, I want to subtract 30 minutes so I added:
A4 is formated as time and contains =sum(A3-30/1440) and gives 10:00
Worked, thanks to those that have posted these questions. Now the
I only want to subtract the 30 minutes if cell A3 is greater than
How do I write that IF statement?
Thanks for the help,
You could have used:
=sum() doesn't really add anything to...If Statement Help #4
I am very grateful for your help, If I understand your sugestion,
would need to write a VBA macro to cut and paste-special the capture
data into a new column?
You would think that excel would provide a more elegant manor t
capture volitale data when it meets a condition that is defined by
formula. Capture being the operative word here.
Is there another function other than "IF" that would be mor
Is there an email address and I will send you a copy o