I am trying to create a worksheet with many drop down lists tha
coincide with each other. I would like to have it where I have
machine drop down list, after selecting your machine, it will the
select the proper list of attachments to match with the machine. Wit

I do not know what is the best way for the below syntax. Any better function
instead of using 0, "" or " " although it can work. Now I afraid if user
enter "  " which is 2 spaces then the program unable to detect.
Need the advice.

I have an excel file that I’ve maintained for over two years now, it has
simple formulas that sum different fields. The formulas are not updating the
way they typically do. For example, if I’m summing column M6 through M12, the
sum does not update if I change a value within that ...

I have data in sequentially numbered worksheets; such as "7-7-1", "7-7-2", etc.
I would like to compile data found in certain cells of these worksheets--the
same cell in each sheet.
Right now I start with something like "='7-7-1'!$O$45" and then just drag

I have a worksheet with 8 columns of information.
I am using the AutoFilter command to display only specific information from
the list.
Is there a way, using formulas, to extract information from only the

can I format a workbook so that every sheet has the same footer

I have been searching the forums but I don't seem to hit the correct
search criterias, please help
I need to create a drop down menu on one of my worksheets. The list
should contain all the woksheet/tabs in the workbook and allow me to

Here is what I have.
I have a Master List with 3 colums The first column labeled location
has a pull down menu with about 20 different options. The middle column
labeled issues is just for text entry. The third column labeled

I would like to change my preferences to never have gridlines appear on my
worksheets.
I don't want to have to change it each time I start a new worksheet.
Can this be done??

I really hope someone out there can help with this problem. I need to
calculate a total for rows that meet one or more criteria, however what
complicates matters for me is that the number of criteria changes, sometimes
it will be one, sometimes four, sometimes three etc etc. I need ...

how do I show a value = a value in a range (A1 = any(b1:b35)?

I am working on a spreadshett to calulate my total hours worked. How can I
add this together?  I have tried to just add the time with the SUM feature, I
have tried to add each item individually...However, the program is adding
these like they are actually times during the day and ...

I have entered a function:
=SUM(IF(ISBLANK(F3:F39),E3:E39,0))
This is supposed sum the values in E3:E39 where the corresponding cell
in F3:F39 is blank. When I open the formula editor box, the formula

I have no idea how to do this:
I have two columns with almost the exact same numbers. What I need to
do is match the columns together so that the numbers that are similar
match each other...for example the list would look like this:

I have various deadlines and I have formatted my cells to have a Green
background if the deadline is met. So the first condition is "Less than
or Equal to." The cell turns red if the deadline isn't met, so the
condition is "Greater than."