I am working on an analysis of responses to a survey. There are 50 questions
which are broken up into 6 sections. I need to provide a subtotal for each
section. The responses are levels of agreement - Strongly Agree, Agree,
Disagree, Strongly Disagree or NA. See the layout below:

I have a 15 employees that are measured in 7 different metrics of their job
function. I need to be able to determine who is performing the best and worst
in each metric and rank my employees. In some of these metrics the largest
value would be considered better while in other ...

Does anyone know how to ge excel to display something based on what I type?
Example. I want to create a schedule, and Bobby Bofinger works 12-8. next to
his name I would put ---- 12-8 ----. I would like excel to interperate this
as 8, as in 8hours. If I can get excel to recognize ...

Hi there im creating a commissions template and need a formula that will do
the following;
If H8 and H12 are both greater than zero AND at least 2 of the following 4
cells are greater than zero (H16, H20, H24 & H28) then put $2000 in I42.

I am setting up a cover sheet that I want to have the user double click a box
and have an X inserted in the box or a check.  How do I complete this task?

I current am working a spreadsheet that has 4 tabs at the bottom, the most
R/H tab being a summary report. When I try to insert another worksheet using
the "insert" function, I find it blocked/inactive. The Excel help menu has NO
usable information whatsoever on why the insert ...

I can't seem to make SUMPRODUCT work with a date field as a criteria.
SUMPRODUCT(range="x")*(range="9/1/07")
I would like for the date range to look for "*/5/*"   ie. amy month, any year.
If I change the range and look for words in that range it works.  I just

in Excel 2003 use functions or conditional formating, how do you copy colour
from another source (reference) text cell to the current cell.  (Being used
to colour code reflecting user entered data and selected colours).

Hi all, is there a way to write a sumif formula where the column of
the data to be summed is a variable?  In cell A1, I have a pulldown
menu of Months.  Across row 2, I have the months Jan-Dec.  I'm trying
to vary the column to be summed based on the month selected in A1.

Here is my timesheet:
c6:  11:00 pm
c7:  12:00 am
c8:  7:00 am

Hi.  Does anyone see anything wrong with this formula?  It returns an
#N/A and I have no idea why?!  Thanks!
=SUMPRODUCT(--(MPD!$B$2:$B$18000=I1),MPD!CE2:CE18000,MPD!$CD$2:$CD
$18000)

I need to combine the following 2 IF statements, or find a different formula
to make this happen.
=IF($K$6="","",$K$6+14)
=EOMONTH(K6,0)

I have a heading in column A.  There are several transactions listed in
columns B,C,D etc. (there are several rows of these under each column A
heading)  I want to extend all items under main heading In column A into one
long row.  I have heard the term "drop column", but cannot ...

I'm trying to get an excel file to auto expire on a preset date. Does a
custom macro exist or can it be done with an Excel function?  Thank you

How do i create a list in excel 2007?  In 2003, you would goto data, list,
create list.
how is this done in excel 2007?
Thanks