I am using Excel 2007. How can I modify sumif formula to sum only cells that meet the sumif and date range critiera?...

Hi All I need a little help. What would be the codes to enter in the Find and Replace boxes so that the second decimal place in any number would be replaced...

Hi, I am using Excel 2007. One of my worksheet has a number formating problem. This worskheet has many (appros 15) tabs. Every time I open the worksheet,...

I tried to re-process strings in a VBA script that parsed some cells to no avail. So I am looking for a function that will do so. Essentially the VBA...

I want to set up 2 different worksheets in one document (workbook), and I want to bring a formula based cell from the first worksheet to be included in a...

I have a worksheet with 5 city names in column A and dollar amounts in column I. I need to calculate the average amount for each city. I use the array formula...

=IF(B270,+B27:B32-B28,"") Want to add B27-B32 and subtract B28 if B27 is 0. If not I want the cell to stay blank. As soon as I enter a number in B27 the cell...

I have these two formulas below working great. I have been asked to modify it by doing the calculation for a period greater than one month. I currently...

I have found a template for a time sheet with everything I want except for the fact that it adds the hour taken for lunch. I need it to subtract the hour...

What I want to do is have a user input time start and end in a time sheet to account for worked hours by using a short cut key stroke but I don't want him to...

freeze column and row on same spread sheet - will only freeze one or the other

I want to be able to put a value in a cell A1 (aka # balls sold) and have A2, aka (ball sales rating) convert it based on the following criteria to a preset...

Hey sorry to bother you guys again, but I've got a slightly different problem now. I used T. Valko's formula =TEXT(EDATE(B5,6),"mmmm") which works great....

I'm trying to design a workbook that has a front sheet where you input all the information, then a function that will copy it to relevant worksheet within...

I currently have outlook 2007 and excel 2003 when I send a workbook as attachment it is never recieved. what is causing this issue?

I have a new question that goes along with this. Is there a way to expand on the cell selection? Besides the names in Column B, I also have data in Columns...

Hi All I have a problem i hope you can help with. The sheet i have has rows of many columns, what i need to do is leave the first 5 columns of data and...

I've read and used Chip Pearson's excellent VBA to count cell colors (http://www.cpearson.com/excel/colors.aspx) It works fine on the background color but...

I have a column with various text entries. I have created a conditional formatting rule for each type of entry but the formatting can be grouped together, so...

I've got integer values in Rows B and C, columns 1 to 20 I'd like to be able to count the number of times where the column values in rows B and C don't...