I need a total row for my table. I went to the Design tab, and it won't let me click on the total row box. Is there a reason that it is shaded grey, and...

I have a column of time values stored as 6:30 PM, 9:30 AM, etc. I would like to calculate the average time of the column. Will the average function work in...

=IF(E78=0,"",IF(E78="","",(IF(H77="",(F77+1),(H77+1))))) =IF(E77=0,"",IF(E77=1,"",((E77+F77)-1))) In the formulas, what does "" mean? The first formula is in...

Dear All, Please help for the below formula. Respectfully, andry =FREQUENCY({1,2,1,1,5,6,6,5,5,10,10,1},{1,2,1,1,5,6,6,5,5,10,10,1}) CSE, result =4?

I have a multiple page project checklist that will be completed daily by the staff. There is a Deadline Date column with a predetermined deadline filled in. ...

This is probably easy, but I just can't figure it out... Here is an example of what I'm trying to accomplish: (Data Sheet) A B C D E F G 1 ...

Normally I know how to paste a link to a spredsheet into a cell in another spreadsheet - however I want to not only paste a link but I need to have the...

For some reason, every couple days my worksheet tabs disappear. I don't click anything specific or make any changes that I know of and then I open excel one...

Hi, I'm hoping someone can help me out with what should be an easy task, but I can't quite get it. I'm trying to do a Vlookup for 2 columns (either/or) using...

Hi! Expert http://www.savefile.com/files/1783586 I think is really Challenging I have data about 9000 and I want to Convert the data of Columns E: E and F:...

Last week I was I had asked for a formula that would give me the yesterday's numbers for an employee that pulled to a Summary Sheet from a table in another...

I am trying to count the unique numbers in COlumn B where the value in Column A=6. I have figured out how to find the number of unique values in all of...

I'm trying to use a "checked Box" , then move information from one page to another page. Can I use an IF message or do I need to do a MACRO? -- Thanks for...

I am trying to shade cells in a row which meet the criteria of the date being 300 days old. I am using Excel 2007 and have tried utilizing conditional...

I’m trying to determine if it’s possible to setup a conditional format using the icon set for the following conditions: in cell A1 contains a date (e.g.,...

I'm still having problems with a formula that was the solution to an earlier problem. The formula below doesn't return a figure. I'm guessing that the format...

Hi All, Ok, how do you change the appearance of a radio button into a toggle button in excel 2007? I cannot find an appearance entry in the properties. I...

I'm trying to create a sheet where I have a series of drop down lists where each item on this drop down when selected gives me a grand total. For example,...

Thank you for your assistance. I'm wondering how to recognize this as a word, for instance. (Cell A3) Apples -5 (Cell A4) Pears - 7 (Cell A5) Total - 12 I...

Sorry - I'm asking for help again! Using Excel 2002 I have a sheet with many thousands of rows of data and I'm trying to use pivot tables to analyse my data...