I have created a sheet that adds up medical biils etc. When I go to add a new line excel will not put the formulas in the new line. How do you change that if...

I have a column of values I wish to sum. However, the data was imported from a database and is entered as text - e.g $,100,000 I have removed the $ (=RIGHT)...

I have a vlookup formula =IF(ISERROR(VLOOKUP(O2,data,10,FALSE))=TRUE,0,VLOOKUP(O2,data,10,FALSE)) which works fine, now I need to add another vlookup...

Question involves summing a variety of accounts in one cell, on a different worksheet (In this example, say Sheet 3). In Sheet1, I have a list of account #s...

Hi, I have the following problem. Data : Profit Commission 100 50 101-200 150 201-250 300 However, the commision is not a flat rate but should...

I have a series of nested IF statements that looks at a column of numbers - some of which are dollars, some of which are percentages. These may alternate...

Hi I have this problem I have many conditions for if function In C9 I have either “ok” or “not ok, if it is “ok” the cell h11 that should be equal or greater...

in excel, when i drag the formula it gives the same value with the reference eventhough the succeding numbers are deferent.

I have added a large number of checkboxes to a spreadsheet and would like to establish a control checkbox which could determine if the value of the other...

Hi. Is there a way to replace embedded addresses? Example, cell A1 contains the following formula =+JAN!A1; where JAN is the sheet name and A1 is the cell...

Hello, I want to apply conditional formating to the following simple scenario, If A1 or B1 is blank then C1 (Font Colour Change) Awaiting for the suggetion of...

I have numerous lists of about 2500 numbers each where most occure twice, but some only occure once and these are the ones that I want to work with. Any...

I'm trying to make a form that if I put a range of numbers from 10.00 to 13.00 the cell stays the same color but, if it is out of that range, it will change...

I have created hyperlinks in a document (separate worksheets). When I add rows, the hyperlink is not updated, with the result that my hyperlink no longer...

I am trying to have a total page for jan-dec worksheets. tabs are labeled jan, feb, mar, etc. I am entering formula =sum(janb4:decb4). How can I add...

I'm trying to generate a Top 10 times list for each grade level (fr, so, jr, sr) from a spreadsheet containing several years worth of race times. The data are...

I need a formula, such as lookup, to extract data from an unsorted column. In this case i'm tring to find the start time for the lunch period. A ...

I have a big table which all the states. Please notice the total column is not always the same and the data for the states are not always in the same rows,...

I have a column which contains the word "Contracted" and all corresponding columns have data which I want to put into another worksheet. I want to creat a...

Help please, what does the following formula mean? =COUNTIF('anotherworksheet'!B:B,"'Area'") I understand the countif function and the reference to another...