How can I get a formula to calculate prior years data for a month to date, month against month comparison with the current year? I'm using the COUNTIFS...

I am having difficulty getting my COUNTIFS formula to select data from a specific date range. I am looking for data based on a or date criteria. All my...

Need your help! I'm creating charts to plot YOY and MTD comparisons of data. My charts' data tables keep populating future months with zeroes even though the...

On a YTD Chart, I need the data table to show blanks, not zeroes for future months. The data sheet which the chart references for the numbers are blank. The...

The worksheet lists card numbers in one column and text codes and package labels in other columns. Some card numbers repeat due to different codes/labels but...

The SUMIF formula in the active worksheet must total the the values in a column for rows in another worksheet that satisfy a different condition in each of two...

The worksheet lists card numbers in one column and text codes and package labels in other columns. Some card numbers repeat due to different codes/labels but...

The worksheet lists card numbers in one column and text codes, package labels, and status in other columns. Some card numbers repeat due to multiple codes and...

Is there a way to enter a function into a sentence in Excel? As in the following example, I am trying to type a sentence with a function to automatically...

I have an Excel07 table with several columns, some with text, some with numbers. I need to find a function to help me show a sum total (on another worksheet...

I have this equation : (1/Do^4)*(T4+T2/Do)=T1-T3 T1, T2, T3 and T4 are known. I need to find Do. How may I solve this using EXEL ? Thanks,

I have the following formula: =WORKDAY(DATE(YEAR(G1),MONTH(A46)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(G1),MONTH(A46)+1,0),2)-5)),-7) basically it gives me the 8th...

Hi folks. I am looking for assistance in trying to figure out a formula. I am trying to count the number of rows in a spreadsheet that have (for example) the...

i am designing a cost spreadsheet for recipes, i need to exclude cells from a formula when, no data is entered, then i need to include the cell when data is...

Is there any way to create a macro in Excel that will go to a cell, wait for you to enter data and hit return, go to another cell and repeat this process. I...

The following is an example of a simple macro I used in Lotus 123. {goto}E3~ '{?}{D}'{?}{D}'{?}~ {GOTO}C8~'{?}~ Once invoked, the cursor goes to cell E3,...

I'm trying to learn how to use IF nested with AND by duplicating a formula in the Asset Depreciation Schedule downloaded from Microsoft's online...

Download http://www.kevinkatovic.com/2009/07/barack-obama-caught-checking-out-girl.html barack obama checking out girl pics

Please help. I have the following two sheets with the following data (actual sheets contain thousands of records, but this is just a sample): "Jan" Sheet: A ...

I have a cell in a worksheet that is returning the correct answers, but I can't figure out why the function is written like it is. Here it is: =+L23 This...