I've created a survey in Excel, which consists of a section that needs to be checked---agree, disagree, not sure-- . I tried using check boxes but found...

I am a relatively unskilled user of Excel at the moment. I have a column of dates where I would like to count the number of occurrences within a week i.e....

Good morning all. I'm currently working on a attendance tracker, I have a formula that will give us either half or full occurrence. Before we didn’t need...

I am using Excel 2007, co-workers still on Excel 2003. When I work on something, I save to 97-2003 .xls to be able to share files. I only use Excel 2007...

I am not a technical person and this might be the wrong group, but I have to start somewhere. I have autofilters on my excel (2003 version) spreadsheet, but...

We should have a df= 48 with n=50. We have df=44.

I have a table where I have my list and it is in a deferent work sheet. When a user selects something from the list I want to match it with my table and...

why has my columns changed from letters to numbers

I need a sales spreadsheet that can add up only certain cells in one column that have a particular designation - such as those products that are ACTIVE or...

I am creating a data chart to keep records of old tenants, I am using cells A thru j, left to right, but top to bottom needs to be left open to continually...

How do I count red dates in a column for a total. I have tried the "get font color"formular, but it does not work. Do I need some kind of Add-in installed.

I am using =now() function in cell A1 and frequently press F9 to update to current time. Is there any way to continuously show the current time running in...

I have a spreadsheet (example below). I want to be able to look up the first value which is a cost center, then within that cost center find an account...

I have a Excel sheet that has 71 rows and 140 columns. In the colums are training courses the employees have taken and in the rows are my employees. I want...

Oh Wise Ones, Excel 2003 SP WinXP Pro I have a date in J4. If I link the contents of J4 to another workbook by using ***$J$4 and I insert a row...

I want to rename the tabs of a new work book with the months of the year jan 09 to dec 09 without having to do it individually. I'm sure it can be done by...

I want to enter a function that in cell B15 will display an empty cell if A15 is blank but otherwise looks up information from a named range in another...

Hi I am using the following formula to try sumif on multiple columns, its not working. Help Please =SUMIF('Sep Rev OR Raw'!A:A,'IP Revenue '!A:A,'Sep Rev...

On Oct 5, 3:49 pm, Dave Peterson wrote: I didn't notice that portion. But glad you got it working. Just a note--did you...

hi, Here is the idea behind the function I am trying to write: "Knowing the width, height, length and weight, what is the price?" ----Box...