Sumif number is greater than a number but less than another number I want to sumif a number in the range is greater than ie 4000 but less than 5000 than return the sum range? How do I enter the criteria to give the results required. Example: Range: A2:A875 Sum_Range: D2:D875 Criteria Need: ?????? Sum if the number in A is greater than 4000 but less than 5000, than retur... 7 May 2010 14:32 Workbook Macro Hi, How can I write this code to place in the workbook of the file, the macro changes the sheet tab name as per the individual sheet cell A1 which is changed from the first sheet Index of Stock, I am looking to do this so it changes instantly when the name is changed and do not need to calculate each sheet, ... 7 May 2010 15:38 Moving certain data to different sheet I need to move data that meets a certain criteria, to another sheet within a workbook. For instance, if a column of data is for a certain ZIP code area, I need it to automatically copy to a sheet for that city. Say, 40202 would go to the Louisville, KY sheet. Because Louisville has multiple ZIPs, I would need o... 7 May 2010 16:45 sumif color cells with same month My file have two columns A - Month B - Amount I will change the color to red of certain cells in column B Can I use the sumif function to total column B of those cells with same month and color red ? Many thanks eva cheng ... 7 May 2010 14:32 Extract unique data I am using excel 2003 I have a file like below Rate month GBP 1.46 FEB 2000 1.47 MAR 3000 1.47 APR 3500 1.48 MAY 1000 I want to create summary Rate FEB MAR APR MAY 1.46 2000 1.47 3... 7 May 2010 13:24 email as pdf print area excel 2007 I've found a flaw in excel 2007. when I filter a column in excel; I can then set the print area and launch a print preview to see the selected area of data. If I choose to send & email as a pdf instead; the same print area suddenly turns into many pages because the capture ignores my filtered area. Technical... 7 May 2010 16:45 SUMPRODUCT again! Hello, I need help solving this formula: =SUMPRODUCT(('Q2'!E13:E150="done")*('Q2'!G13:G150="14521")) where the numbers of "done" items is counted under department 14521. This formula works with many departments but skipped department# 14521. But if I put a letter, say like 14521S, in my Q2 datasheet and chan... 7 May 2010 16:45 validation hi, I have a workbook with 2 sheets. In one sheet I have a calender and other sheet just list of names. what i want to do is: In the calender sheet if i have a name under a date and when i enter that date beside that name in the sheet of name list, i want to have a message saying that he/she is on vacation. ... 8 May 2010 02:36 Dividing Worksheet into Two Columns Greetings, Is there a way to, in page setup or somewhere else, divide the worksheet itself into two columns, much like Word document? I have a measly four column spreadsheet going but it's long (over 1400 rows). Looks crappy on print preview - could easily fit two sets of these four columns on a single page ... 7 May 2010 15:38 Link future workbooks to a summary workbook... I have an excel template that I use to create new workbooks. Is it possible to set-up a summary workbook that looks through a specific folder and inputs all the values in a specific cell into the summary workbook? For example: Cell A1 is a persons name, Cell B1 is an account #. In the summary workbook I want ... 7 May 2010 12:16