I am trying to tally the fields in several sheets of the same workbook. I
can use either hidden fields or link one cell to a hidden sheet with several
lookups, but would really like to put it all in one cell. I've put an example
below of what I would like to do. Is there an easy ...

For the reference syntax of my offset formula I am using the Address
function.  What I need is A1 but of course the Addres function returns "A1"
which means nothing to the offset function.  how do I get the address formula
to just return A1?  I suppose I could use MID, but is ...

Another software exported a list of values in the form of: '325.000',
complete with the apostrophies. How do I extract just the number itself to
the next column over?

I have a spreadsheet (F) where each functional cell has a formula that adds
the coresponding cell information from 13 other worksheets (F1, F2, . . .
F13).  These are 13 different sources for counts of information received in
15 minute intervals over a 13 week period.  

I have a Project Summary form that contains a "Dashboard" tab and 4 other
tabs (Project Scope, Project Status, Project Change, and Project Closure).  I
want the dashboard to give viewers a quick snapshot of the project status.  I
want the dashboard to reference the Project Status ...

I have a Project Summary form that contains a "Dashboard" tab and 4 other
tabs (Project Scope, Project Status, Project Change, and Project Closure).  I
want the dashboard to give viewers a quick snapshot of the project status.  I
want the dashboard to reference the Project Status ...

I'm trying to do a multi-criteria count across worksheets and was
wondering if anyone had any suggestions.  The number of sheets may
change occassionally, so I'm trying to avoid having to do the
calculation over each sheet then sum the results.  What I'm trying to

I am trying to match a name on one spreadsheet with a name on another
spreadsheet to receive a resulting contact.
For example on sheet one the following is shown:
A                

Is there a way to modify Chip Person work day function so that it will
list First Workday of week and last work day of week.
For example:
Jan 7 - Jan 11 2008

how does one convert WK4 macros to XLS for excel 2003?
thank you.

I have a chart that has a row of data at the top.
One cell, let's say O5 has a value, let's say 5.
I need to search the O column for the value (5).
When it locates the 1st line with a 5 in column O (let's say O18) I

I am using =VLOOKUP($A$32,Data!$A$4:$M$18,MATCH($B$3,Data!$B$4:$M$4,0)+1,0)  in order to search for two dimensions in a table.  I am a very green user so do not know much in the way of Excel.
The problem is when there is no matching field I receive a #NA.  How do I just get a ...

I am trying to trim a spreadsheet with a lot of text similar to the following
text below, where I want all characters BEFORE the APCo: 30/ deleted. Someone
told me to use TRIM(*30/ ) as a wildcard rather than count out specific
characters, but I can't get the formula to work. Any ...

I have 7 customer service reps that take inbound calls.  I need each of them
to use a call log sheet on Excel and then I want to be able to consolidate
the data from all 7 call logs into one master spreadsheet.  The data on the
master should update automatically from the ...