Trying to use "AND" function in criteria portion of "COUNTIF" function. More specifically want numbers to sum if the number in the "range" falls between two...

Hi, xl2007 formula "COUNTIFS" as following:- =COUNTIFS('MTD Reach'!K:K,"0",'MTD Reach'!A:A,B12:B277) *Criteria range 1 = 'MTD Reach' (Sales data) *Criteria...

I'm trying to write a formula that will "count" the number of entries in a list that are greater than one number but less than another.

Dear By using the help level I have created dropdown list in one work book. I want to use the same list in another workbook by linking the same way (insert,...

How can I auto fill a column with a formula referencing to consecutive columns in another sheet? Example: A 1 =OtherSheet!A1 2 ...

I'm trying to create a rollup column based on a pivot table data column. The GETPIVOTDATA function includes static field and index ("item") references, and so...

I want to be able to control a user's input to a couple of test words such as "Yes" or "No" or a date. One of those 3 options and of course the dates input...

I need a pop up box with large fonts then the msgbox is using. Is there a way that I can change that FONTs size and color? if not were do I go to find some...

Hi everyone, Is it the same when you type in 01/01/2000 as in a date format AND when you pick up three different numbers from three different cells and...

i AM ATTEMPTING TO DO AN ELAPSED TIME CALCULATION USING THE "DATEDIFF" FUNCTION SUGGESTED IN SEVERAL POSTINGS ON THE DISCUSSION GROUP. WHERE DO I FIND...

Hi, I'm puzzled why Excel 2003 gives a difference in days as "-2" when using Feb 28th as the start and end date. I have the following dates in two columns...

i have several industry group names in a column - general example: A5 thru A10 contain "Electronics" (5 total) A10 thru A15 contains "Electronics...

I have two Excel files (both are lists using three columns) with the same formatting. I cut and pasted several hundred rows from one file to another. I'm...

How do I delete a blank worksheet w/in a saved workbook file? When I go to select 'delete' it is greyed out.

I would like to manipulate dates in an excel worksheet (that is avoiding VBA, I guess i could accomplish my goal with VBA) in a way that would make my...

Hi, there. I found that the "Design" manual was disappeared (or gray out when added a new command on the quick access tool bar) after I exported the...

I need to put a legal disclaimer on all printed excel pages. The disclaimer is too large to put in the Footer. Any ideas on how to do this?

I use the "edate" function in Excel to determine the first day of the month going back from a termination date...for example: If a lease ends March 31, 2007...

Hello everyone, We recently upgraded some of our users from Office 2002 to Office 2007. Most of our managers are used to running queries through the Excel...

If the holiday vector in NETWORKDAYS(start,end,holiday_vector) contains any "null" strings (i.e. they've had the value "" inserted), then NETWORKDAYS() returns...