I've tried the following simple IF test as a check on totals in a sheet where I'm compiling accounts: =IF(C24=SUM(C25:C50),"","!") bizarrely, C24 and the...

I am trying to apply a multiplication factor that would vary depending on the sum of a particular cell. For example let's say the value of cell A5 is the SUM...

I have defined a formula that tests the value in 3 columns. If the value in each column passes the test, the formula calculates a value for another column. ...

I'm trying to come up with the avg/mile for race times. Is there a formula or setting that needs to be used?

I am using vlook up in a list of accounts that varies from week to week. How can I make vlookup return a 0 or blank rather than the pesky N/A when a...

can I nest a sumif function within a sumif function? i want to sum the data with in column c if data in coulmn a ="a" and data in column b="b" Here is what...

Hi i have a sheet for employees that capture weekly hrs for workers, after four weeks i now want to use a function to sum all monies paid to each individual...

I am creating a spreadsheet with a tab for different time zones... to convert from the eastern time sheet where the times are manually entered, in the...

Hi My data is in range B7:F8. Row 7 and 8 is merged (B7/B8, C7/C8 ... E7/ E8) is merged. Therefore in all I have five cells. I want an input "X" or "x" in...

I'm doing a sum on a single column of numbers =sum(d3:d50). After updating new values to the column I now must save the worksheet to view the updated formula...

Where is this mythical fill handle. I have it enabled, but I can't find it. Thanks!

Hi! I have a worksheet with several tables. The tables are linked to each other using functions such as LOOKFORROW and others. I want to calculate the...

everytime i type a phone number in a cell the zero dissapears, how do i stop this from happening. many thanks in advance

I have a vacation/training tracking spreadsheet where there are 5 rows for each associate. The body of the section has month titles (jan - dec) and below...

i have a lot of stocks with info like GRN date, qty, value, lead time etc. I used pivot table to consolidate as some items has a few lines because of...

Is there a way to create a IF statement that results in the cell format changing? For example, if the resulting value is True than the cell turns blue, if...

I am trying to calculate the total time it takes to resolve an issue within an organization that has a 24 x 5 work schedule during the week and 9-5 hours on...

I would like to put a formula into a sentance, the sentance is not allows the same so I can not have it in two cells and print it the way I want it...

I am trying to set up a cell for each row that shows when that row was last updated... any suggestions?? thx

I have a large spreadsheet and based on a status indicator in Column DW, I need to shade the entire row one of eight colors, For example, if a cell value in...