General

Sum if
I need a formular that add a specific criteria or else just put a Zero. For example: I want to added column a with all January's data in column b or else just place zero fi there's no data. a b January 12 February 24 March 36 January ... 17 May 2010 13:33

last sort selections won't save in Excel 2007
On one computer, when I sort in Excel and then attempt to sort again it doesn't save the last sort selections. Normally when I select the same sort area, the last sort selections appear when you bring up the custom sort, but on one of our computers that is not happening. ... 17 May 2010 13:33

Creating a chart with varying data value ranges
I have a chart that I want to show home price data with. The chart will have data that has very significantly varying data values. For example, one line graph will be 50-100, one will be 400,000 to 500,000, one will be 90% to 110%. I would like to show these line graphs on one chart. How to I make a chart w... 17 May 2010 13:33

Read-Only Recommended
Is it possible to set a document as Read-Only Recommended in Office 2007? It was pretty easy to do so in 2003 but I cannot find the option in 2007. ... 17 May 2010 14:40

Excel 2007 Read-ony issue
recently after I opened an excel file that I have been using for sometime now. I made some modification to the content of a spreadsheet. When I attempted to save it i get a read-only restriction. i attemtp to save as under a different name and it does it again. now I cant save my changes and I dont want to loos... 17 May 2010 12:26

How do I delete cell formats but not the content...
I am trying to copy data from Excel to use in Word and would love to get rid of the cells but not the data that is stored within the cells. ... 17 May 2010 12:26

Excel Drop Down Box
I have Excel 2003. I have created several drop down boxes. I need to know how to assign a value (ie a dollar amount) to each choice in the list. For instance, if a person picks option R1 from my 1st drop down box, I want R1 to have a value of $10.00, but if they pick P1, I want it to have a value of $5.00. ... 18 May 2010 12:35

Complex Counter
I need a counter in H2 that counts the following: If J2 > 10/27/2009 then add 17 to H2, Add 10 to H2 for every cell from M2 thru AS2 that is greater than 10/27/2009, If AU2 > 10/27/2009 then add 11 to H2, Add 1 to H2 for every cell from AV2 thru CA2 that is greater than 10/27/2009, If CC2 > 10/27/2009 then add 10 ... 17 May 2010 11:19

Matching two groups of data within one sheet
I have two groups of data A2:D1564 and F2:J1417. Each has a column (D & F) with 10 digit assignment numbers, most of which match from the 1st group to the 2nd. I need excel to match them keeping the other data in the row from each group with the assignment #. My second group has less rows of data, so for som... 17 May 2010 10:13

Countifs anchoring formula when sorting
My Countifs seems to work as long as I do not sort. For example, I want to sort by date rather than name: • Bob Smith that was on line 12 is now is on line 148. • In the Countifs formula Criteria 2 it is referencing cell C12 and returning Jane Doe's information from the other worksheets. I have tried an... 17 May 2010 10:13