I teach seniors the fundamentals of Excel when I came upon a problem.  There
are two rows and four columns of data shown in an example problem for the
students to work on as follows:
2001               2002            2003              2004

I have a workbook with one sheet (Sheet1)
In cell a1 I have the value "1"
In cell b1 I have the formula "=a1"
In cell c1 I have the formula "=Sheet1!a1"

Hello, I have put the following formula in to try and add figures together
but only when a certain word in in the first column. Can anyone see my
mistake?
=IF(C3:C207="CA",(COUNTIF(I3:I207,"OG")))

EMAIL ADDRESS IN SPREADSHEET SHOW UP AS LINKS ON SCREEN THEN DO NOT SHOW UP
AT ALL WHEN I PRINT.  CAN SOMEONE TELL ME WHAT I AM DOING WRONG?  I NEED TO
BE ABLE TO PRINT THESE SS AND DELIVER BY SNAIL MAIL.

If I open a Excel or Word file from a folder it takes a good 15 seconds for
the file to open. If I start Word or Excel first and then do a file, open,
the file will open instantly. I dowloaded the trial version of Office 2007
after this started with my Office 2000 and 2007 does ...

i want know information about this man pleas

Guys
I am programming up a macro in Excel, I was just wondering how to loop
the range function.
Whereby I would like to somehow put a variable in the function Range,

I forgot my password to logon to Passport.net. How do I acquire a new one ?

Has anyone any idea where I can find a spreadsheet template for setting up a
shift roster?
Thanks - Dave

I would like to show week numbers inside a cell that also contains the date e.g
In cell A1 "01/01/2007 (1)" (1) being the weeknumber for that date, hope
this makes sense, I have looked all over many of MVP website and can not find
a workaround.

These questions are more out of curiosity than anything else.  I have
been experimenting with VLOOKUP with an exact match, and would like
some background to what seems to me to be curious behaviour.
In cells A1:A4 I have

How can I include all Saturdays in a perpetual calendar,yet exclude my array
of limited holidays AND exclude all Sundays using the NETWORKDAYS function?  
Essentially, I want Excel to calculate the number of workdays in any given
month in any given year(include Saturdays) then ...

I copied into Word, a property assessors records (Owner's Directory)
online for a given community in Florida.  Then I went into the
indivdual proerty manually  and recorded all sales from Jan 2000 to
current and I updated each line of the owner's diectory by adding 3 to

I am creating a sales order form for my boss. He would like me to have a
drop down box for the customer name and then would like for the customer # to
automatically pop-up in the box below it.
So I am using a VLookup but can't get it to work. I did try reversing it. So

I'm not sure how to explain this!
I need a total of the number of times that "G" (no quotes)
appears in the range S4:S1516, based on "Ou" (no quotes)
appearing in the same row, in the range J4:J1516.