I have 20 salesmen, each with different quotas and start dates. For example Guy A has $424 in and shows 57% since his quota is 783 YTD. But Guy B has $18...

When I hit the Start button, then Turn Off Computer, then Standby I receive this error message. Windows cannot go on standby because Microsoft Office...

I am having trouble understanding vlookup. Is there a tutorial for this function? What is the best way to figure it out? I have tried using the help, but...

Whenever I change the first component of an established ratio of 50:1, first a yellow box pops up that reminds me the ratio is supposed to be 50:1. Then,...

My Data Situation: A B 33007014220000 33007014220000 DLL 33007014220000 CND ...

I would like to run both the indirect and sumif functions in the same cell and am not quite sure how to structure it. Any help is greatly...

I am running SUMPRODUCT with 3 criteria, 2 are on another sheet and one of those two is searching for a portion of the cell content. I am getting #N/A as the...

I have a worksheet that is using the sumproduct function based on criteria on another sheet. I need to use the same function in other cells so I am using the...

I have a sumproduct function with two criteria, one of which is only one word of cells that contain several words. I have tried using wildcards but the result...

I am trying to run sumproduct with two criteria, both with a horizontal range. It does not seem to be working and is returnig a zero count. Here is what my...

I am trying to use countif where the criteria in some cases will be one word from a cell that has several words in it. I'm getting a total count of 0 in these...

Hi Rick, Thank you for calling my attention for the lack of details with my question. My question is: I posted a shared worksheet in a shared drive that...

I would like to have my excel worksheet protected but when I do the Outline/Grouping Feature to collapse/expaned is disabled. Your ideas/comments are...

How do I set things up so that a custom function automatically recalculates when a cell value changes? I have function which calculates a value based on...

I need to take the row value of the cell in which a function appears and pass that value into the function itself. As in the example below, cells A1, A2, A3...

How can I filter the values listed in a drop down list based on values present in another cell? As in.... Category Description Warehouse Warehouse...

I am attempting to create a spreadsheet that can be used to show if an order is complete. Some orders contain only one line and a simple IF statement tells me...

I am creating a summary page for multi worksheets. Is ther a way to have a cell mirror a row of info on the summary if a specific word appears in a specific...