I'm trying to add another criteria that will look at the cell in column Z to
see if the record has been tagged for use in report(s). Column Z can contain
one or more tags. Multiple tags would indicate that the record is to be
included in more than one report.

I have a range of data listed like this:
             Date1        Date2        Date3      Date 4
Data1
Data2

I have a spreadsheet that will eventually consist of over 30 sheets.  Each
sheet will have information that I want to be entered into a formula on a
totals sheet.  Is there a way to have formulas automatically update as I add
a new sheet?

How do I calculate the weekdays between 2 dates in an Excel spreadsheet

To an email, I attached a document that contained a hyperlink.  When the
addressee opened the document, the hyperlkink did not work.
should I have locked the hyperlink in some way prior to sending the document?
thanks! jane

There is data like this in excel:
       Q               C       C         C
A      10            100    110     150
B      20             300    330     370

I'm trying to create a formula that adds a column and then divides its total
by 60? Simple you would think but I cant get anything to work. Help!

Can you help me out with this? if works fine if the external source i
open but returns a #value if its closed. is there anyway of correctin
this
--

i have a series of 5 numbers separated by commas listed in one cell. i would
like to extract each number and list them in separate cells. what is the best
way to achieve this? thanks

I am trying to find a way to do this:
The boss has a master sheet of products he requires from different
suppliers, once he has selected what he wants, he will go throught the
list and give PO numbers, there are times the same PO number will be on

I have a coulmn with a heap of dates in the format of dd/mm/yyyy. I
want to find the earliest and the latest date in the list then
calculate the number of days that lie between them.
NB: not all the cells within the coumn will have a date, some cells

I have a work book of about 11 pages. I want to link page 1 Row 1 to Page 2
and so on. When I go to type new information on Page 1 and enter a name that
I am assigning that row to I want it to trasfer to the other page weather it
be Page 2 or Page 10.  Looking for suggestions. ...

when I make a spreadsheet, and then try to print it all my information shows
but not the cell outlines. is there a way to show the cells on my printed
paper?

I have a spreadsheet that records members of an 13 to 18 year old disco club.
We record their Name, Address, Post Code, Phone Number and Date of Birth.
There are over 450 members.
What i am trying to do i get excel to alert me as to when a member reaches

Hi
I have a list of exam results, in one column.  I am trying to count how many
scored in 7 different ranges.  I have tried the countif, frequency and sum
if, do not really know what I am doing wrong.  I want to know how many