Search results for query: *

I mistyped the formula the first time once I realized that I corrected my mistake. In the cell that I wanted the formula to work in is: B2-SUMPRODUCT((C12:N12<>"NO")*(C11:N11))

I must have done something wrong with the formula the first time because it didn't work, but now it does. Thanks for the help

Using the Excel image that you provided...

What I want to do is get the sum of one row where I have a "NO" value on another row and then subtract that sum in another cell. Say I have a value of 1,000,000 in cell B2 Then further down in the spreadsheet I have 12 columns with data in two rows. In this example my value in cell B2...

Never mind I figured it out. =cell with value + SUM(1000000-cell with value)

How can I make the value of a cell be a certain amount but use the amount of another cell and then add the difference to the value I want. To make things simple. Let's say that I want the "target" cell to always equal 1 million but the other cell is 250K. How can I create a formula to grab...

I have no choice, the data is in two different tables. I need to mark if the product is two different locations, in the product table only

I am trying to create an update statement that will update a column. Here is the scenario. Let's say I have a bunch of products and I need to tag any of those products that exist in two different locations. Note the product can be in the same location more than once at times, I don't want to...

I have a form that is shown as a datasheet view when it's loaded. During the loading of the form, I would like for it to do a "calculation" that if the "Refill Date" is greater than the "PA Date", it changes the "PA Required" to TRUE. But I need it to check all the rows as the form loads. I...

Thanks, didn't realize Access had conditional formatting like Excel.

I was wondering how I can look through a datasheet that is a sub-form to find a record based on date. So when I open my form, it looks at the sub-form and loops through the records and when it finds a row with today's date, it changes the background and font color but puts it back to the normal...

I'm sure this has been asked several times but can't find anything on it. Here is my situation. I have a spreadsheet with data in columns A through L and in several hundred rows. I want to highlight each row from column A through L, if the value in column "J" is a specific text value, in the...

Hopefully I'm in the right forum. Here is what I'm trying to do. Below is an example of the workbook,the dates are in column A. When I open an Excel workbook, I want the focus to go to the date column. Using today's date, I want the focus to go to the cell that has the date of 09/30/2014...