If I wanted to sum values in Column D only if the values are between 0 and 100, how would I do that? Obviously what I have here isn't correct in this...

2. I have some long labels on a spreadsheet. Instead of having them spill across columns, or get cut off because the column is too narrow and the next cell...

Hi, I have a problem when counting a column of numbers, in that the count is not correct. To explain, the count should return a number of matches in which...

I have X and Y column data, and want to set a cell equal to the trendline values of that data, but I want the trendline equation to represent a 6th order...

Does anyone know how to apply a function so that works for the following example: combo box containing pass and fail, user selects fail, goal is to have a...

Is this the right place to ask abo

I have several sheets of budget numbers that are linking from one sheet to another. In linking several sheets by pulling totals from one sheet to create other...

When entering a sixteen digit number into a cell which ends in a number other than "0" the number appears properly at the top of the screen and in the cell...

How can I save a single sheet in a workbook under a new name?

How can I email a single sheet from a workbook? Do I have to cut and past into a new workbook and then send the new workbook, or is there a short-cut??? ...

Hi I am looking at excel worksheets with a view to making them less verbose. For instance there are lots of formulae of that repeat variables eg = Sum(A6*U6,...

Hi All, You must be fed up with questions on time functions, but here goes. I need to reference a cell containing NOW(), to count seconds giving a...

Hi, I have a function in one project that I am trying to call from another without any success. Going through the documentation it looks like I should be able...

I have and excel spreadsheet designed to appear as a floor plan. The cells appear to all shift towards the right margin. I want to center them so they are...

D2:D101 has a data validation list (ten two letter codes) applied to it. I want to apply the same validation list to E2:E101 and F2:F101 but want to limit the...

I would like to select individual names from a database of names randomly for a drawing. Can someone send me the steps.

Is there a way to apply conditional formatting if a date is less than 30 days from today's date? Ex. to highlight something that will be expiring within 30...

:confused: do you know which formula I can use to count in a column certain values based on criteria of another column? For example: Column A ...

Trying to take date values in a spreadsheet in this setup... 03/15/03 03/15/03 03/16/03 03/17/03 03/17/03 But my issue is that when I read these values into...

I have a user that is opening a worksheet that is stored on a public drive and when she opens it,all the data is unreadable, but the graphs are fine. But when...