Suming using 2 criteria
Sheet 1 has
Sheet 2 has
A B C
Bob 10 Q
Dan 15 W
Pete 8 E
Ted 12 R
Mia 22 T
I want to sum(sheet2!B1:B100) where (sheet2!C="W") and (sheet1!B = "Y" where
(sheet2!A = sheet1!A))
I know it can be done but I can't figure out the formula construct.
In article <uyNN$euYFHA.3620@TK2MSFTNGP09.phx.gbl>,
"Hall" <email@example.com...One Day Out when Using EoMONTH in 1904 Date System : Excel 2007
Is anyone else experiencing this issue when using 1904 Date System within
Excel 2007? The date it returns appears to be one day less than it should
=EOMONTH(c1,-1) return 29/09/2008 rather than 30/09/2008
1 =EOMONTH(c1,-1) 29/09/2008 01/10/2008
2 =EOMONTH(c2,-1) 30/10/2008 01/11/2008
It seems to be the same for all dates when using this system, but works ok
when using the normal default date system it work OK.
Is this a known bug?
Yes, I just confirmed this issue! I ...Excel 2007
I am not really sure what to call this or if it's even possible, can you
freeze a row, then while scrolling down have the frozen row be replaced by
another row that will be frozen and so on?
I freeze row 5 which has column headers. As I scroll down the spreadsheet I
reach row 100, which has different column headers. Can the headers be
replaced so now row 100 is frozen? But at the same time once I scroll back
up above row 100 it would resort back to the headers in row 5....
Put the disparate data on sheet2
> I am not really sure what to...Using IF statement with sheets
I have several sheets named with the date such as 4.8 up to
5.8. On each sheet have rows of data with calculations for
percentages of trying to determine if the row of data is at 3%. I
created a tab called Summary. I am manually inputting the row of
that is above 3% by going to each tab(sheet) and doing a filter and
looking at the bottom left hand corner of the screen that displays
number of rows above 3% in the filter. Then I input that number on
the Summary sheet.
row 2 col a 4.8 and col b 100
row 3 col a 4.9 and col b 50
What I'm trying to do is th...Automattically generate Microsoft Exchange Views....what to use?
I am using Outlook 2003 to bring down pop3 email and also synch with
Should I have the "Automatically generate Microsoft Exchange Views" box
ticked? Outlook seems better with it unticked. Iam beginning to wonder
if that was the cause of my hangs.
JohnPerry@redoak.co.ukNOSPAM (delete NOSPAM)
No, that setting is relevant only if you're connecting to Exchange server.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlook...print odd / even pages of 8.5x5.5 booklet
I have a 16-page booklet, 8.5" x 5.5", and I want to print this on my Canon
i560, which prints on only one side. I set up the paper as landscape and I
want to print half the pages, turn the paper over and print the other half on
the back, resulting, I hope, in an 8.5 x 5.5 booklet, folded, saddle stapled.
But I can't see any way either in Publisher or Canon to print on the "odd"
then "even" pages. Of course, when I print half of the pages, I want to get
two 8.5 x 5.5 pages on one side of an 8.5 x 11 sheet, for instance, pages 2
and 15. Then I want to pr...ON 2007 note container moves by itself
Hello, I have a frequent problem when putting note containers and objects
over images that I clipped. Everything seems ok for a while and all of a
sudden, if I click above one of these containers or objects, all of them
below the mouse click will move to the bottom of my clipped images.
I just cannot find the logic either the sequence that triggers this
misbehaviour. Can somebody help ?
> Hello, I have a frequent problem when putting note containers and
> objects over images that I clipped. Everything seems ok for a while
> and all of a sudden, if I click...how to use publisher to do a 52 page handbook
I want to use Publisher to do my school handbook instead of word. It will be
a 52 page book with a heavy stock cover. Any suggestions? help?? resources
to look into?? Thanks in advance Ron
> I want to use Publisher to do my school handbook instead of word. It will be
> a 52 page book with a heavy stock cover. Any suggestions? help?? resources
> to look into?? Thanks in advance Ron
Thanks for your response JoAnn. The handbook is going to be printed
in-house in our school. The printer recently purchased does collating and
binding. I am ...exchange 2007 delayed sending
a while ago I posted a message about delayed sending being stuck in the
outbox in outlook 2007
outlook can not be closed as then the email is not send
now I am trying to do the same but using outlook in online modus
instead, the messages are now send immediately
this even though the message header in outlook clearly states that the
message is not to be delivered before "date and time" (in the future)
how can I find out why this feature is not working (as expected)
This artical is very useful and it applies to Exchange/Outlook 2007 as well
http://blogs...Word As an Editor
Is it possilble to associate MS WORD as the editor of e-mails in CRM,
similiar to the feature in Outlook?
There currently is no supported way of doing this in any of the CRM E-mail
Even if you did hook this up yourself (which would be no small task), I can
foresee a number of issues having to do with the fact that CRM expects all
e-mails to be either plain-text or HTML; there is no support for rich-text
formatted e-mails. It would also be a challenge to get the Word editor to
work with CRM's e-mail template feature.
Director, Software Development
invokesyst...Use of the VERSION field in database
I noticed that there is a field called VERSION in many of the tables. I am
assuming that it is the means for tracking the number of times the record
has either been touched or viewed. Can someone please clarify this?
On May 28, 10:29 am, "John Cosmas" <johncos...@charter.net> wrote:
> I noticed that there is a field called VERSION in many of the tables. I am
> assuming that it is the means for tracking the number of times the record
> has either been touched or viewed. Can someone please clarify this?
I would guess that vers...using outlook can you receive without tapping on receive messages
I would like to be able to see new messages in my in box without having to
use the receive tab. Is there a way to have them just come into my inbox
without tapping on receive
Set up automatic mail polling every 10 minutes in Tools, Options.
> I would like to be able to see new messages in my in box without having to
> use the receive tab. Is there a way to have them just come into my inbox
> without tapping on receive
I tried this advise and it still does not work.
> Set up automatic mail polling every 10 minutes in Tools, Op...Booklet #3
I am proiducing a 82 page booklet, which was done in Word last year.
A) When printing the page numbers don't show.
B) How can I delete a one off pages, when the screen always shows 2 pages
A. Did you insert page numbers within Publisher? Do you have ignore background
checked in view?
B. View, uncheck two page spread.
Mary Sauer MSFT MVP
"Squashed Tom" <SquashedTom@discussions.microsoft.com> wrote in message
news:538E7EDF-7613-40D7-8CB1-79...using scroll mouse in excel 2003
after a while my mouse will stop scrolling up and down and just work left to
right. The only way to resume the up and down scrolling is to close my
worksheet and reopen. What can I do?
...minus using pivot table
Can someone help me with minusing data using pivot table or any othe
way, for example:
Emp id Time
Data I have is emoloyee ID and various time that they performe
something in system. In the result I want to get Employee ID and tota
time they were in the system.
This means final result should be
Emp id Time
It just should substract the lowest time from the highest time.
Thanks in advance..
Message posted from http...Outlook 2007 settings
I had a problem with 1 user's Outlook
User is connected via VPN with a large mailbox
Few days ago the profile became corrupt and he can't get new mail - all the
old stuff is still there upto 8 Jan
Seems not to want to login to exchange and I can't change settings either!
So created a new profile username1 but when I did I must have used the admin
(I know - not good!)
Now everytime he loads Outlook it requires admin password!!
(tried the users own Server logon but it didn't work)
Is there anyway to change the Profile password??
I can create a new...Using object model to coult the number of used rows
Does any one know how to count the number of used columns and rows in a
sheet via the object model
int m_columncount = m_CurrentWorkSheet.Columns.Count;
gives the total columns, but what I need is a count of the used colums.
Or do I need to write a manual count i.e. manually count how many are used
by by checking each element?
The following will get the number of rows in your used range
as you would observer using Ctrl+End
dim rowCnt as long
rowCnt = activesheet.Cells.SpecialCells(xlLastCell).row
Take a look at
http://www.mvps.or...conditions using colors
anyone knows if there`s a way using conditions, to fill the cell with
colors?, i mean not filling all the cells manually?
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
Use Format > Conditional Formatting
Post back if you have problems.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
I have a page on Conditional Formatting
http://www.mvps.or...Using a Check Box as a Condition
In tblHorseDetails I have a 4 Fields
[Invocing] Yes/No, (Check Box)
Effectively you set your horse up with one or more Owners with there percent
in that 1 Horse
I am trying to do is that when that record has a False in Invoicing it will
not create an Invoice
Below is the Code for Distributing the Invoice at the end of the month
Or do you think it has to been done in subSetInvoiceValues 16 row down
Any help would be much appreciated...............Bob
Private Sub cmdSave_Click()
Dim recHorseOwners As New ADODB...Printing in A5
Greetings from Downunder
The items I need to print are similar to greeting cards -- A5 size in
landscape orientation 21 cm wide & 14.7 cm high, side fold -- giving me four
pages each 10.5 cm wide and 14.7 cm high. Creating this is no problem and
all appears perfect right up to "print preview', even appearing correct in
my printer's "print preview" screen. However, when I print, the contents of
each page have changed their orientation to "portrait", and are 90 degrees
Would anyone out there have a cure for this?
Using XP Pro + SP 2, MS Office 2003...In Publisher I need to make my page to A5 size
I am trying to create a publication for flyers but I don't know how to get
the document changed to A5 size to print
Ideally you would have designed it to be the size you would be printing
but... Try converting it to a .pdf file and then print that to fit an A5.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"treecey" <firstname.lastname@example.org> wrote in message
>I am trying to create a publication for flyers but I don't...Graphing using text??
I am a schoolteacher and grade pupils on levels which have lettered bands
within, such as 6a, 6b, 6c etc.
Is there a way to plot these on an excel chart without meassigning them
values, such as 68, 65, 62 etc?????
Maybe it is a programming issue so I post there too.
You do need to assign numerical values, because Excel plots text as zero.
You could use a lookup table for this. To make the axis display text instead
of numbers, use a dummy series as your new axis:
http://peltiertech.com/Excel/Charts/Y_Cat...Use a vlue of a cell for the sum range
I want to use value stored in a cell (lets say C1) to use for SUM function
For example SUM(A1:AC1)
C1 bing a value stored in cell C1, may be 5
A 5 in C1 would sum the range A1 - A5
> I want to use value stored in a cell (lets say C1) to use for SUM function
> For example SUM(A1:AC1)
> C1 bing a value stored in cell C1, may be 5
Thank you Mike for your help :0)
"Mike H" wrote:
> Try this
> A 5 in C1 wou...Outlook converting word file to winmail.doc
Hello, When sending a regular (rich text) e-mail from
Outlook 2000 that includes a MS Word document, the
recipient receives a winmail.dat file (instead of the MS
Sounds like a configuration issue that's probably been
addressed before...Does anyone know what setting (or patch)
I change to correct?
Thanks in advance, Frank
...Simple Exchange 6.5 move to Exchange 2007 ?
Is there a simple way to move Exchange 6.5 from a Windows 2003 SBS server to
Exchange 2007 on an SBS 2008 server with the same domain and computer name
as the SBS 2003 server?
We are currently planning to:
Create the users on the SBS 2008 server from scratch, not migrate them.
Use Outlook on each client to import their e-mail into the Exchange 2007
server from PST files exported from the 6.5 server to PST using Outlook.
That seems cumbersome and time consuming. Is there a way to backup the store
on Exchange 2003 on the old server and restore it to Exchange 2007 on the