How to sum by month I have a sales order spreadsheet that gets updated daily from our ERP system. The worksheet has the following columns: 1. Customer code (each customer could have several entries per month) 2. Order date (the current worksheet has two years of history in addition to the daily updates) 3. Amount What I would li... 24 May 2010 17:57 personal.xls Random question. for some reason my personal.xls file does not open when i start excel. it was now it isn't. for some reason i have to go into the folder and double click the file. Does anyone know why this is and how to fix it? ... 24 May 2010 15:44 How to have a cell auto resize the font to make text fit in cell? I'm using Office 2007, and I would like to know how to make the font size automatically adjust to fit whatever I type into an individual cell. ... 21 May 2010 15:03 putting a date in an if statement When i write an if statement taht says this =IF(J2<6/1/2010,"N/A",J2), it always comes up false. How do make it see the date? ... 21 May 2010 21:39 How to retain part of formula's criteria as static Below is a formula that I want A50:A100046 to remain static so when I "fill down" the information doesn't change. =SUMPRODUCT(--(MONTH(Data!A50:A10046)=7),--(YEAR(Data!A50:A10046)=2008)) Can you suggest how I can write the formula to accomplish my goal? (Just an FYI: I'm basing the month and year on a fis... 21 May 2010 15:03 IF Function I have this formula currently set up... =VLOOKUP(\$A14,\$B\$7:\$J\$10,5)*W14 but I needit to not reflect the calculation if W14 has a "-" dash in the cell. I've attempted to add in a If formula to this but it isn't working out. Any sugguestions are greatly appreciated. ... 21 May 2010 16:08 Sum in a column if there are 3 conditions in another column I need to find the total from Col B if Col A is one of the 3 possibilities A B DONE 0 DONE 60 OBS 40 POST 55 DONE 40 DONE 0 DONE 47 POST 55 DONE RESULT OBS RESULT POST RESULT ... 24 May 2010 12:21 HOW DO YOU FORMAT A DATE? I KEEP PUTTING ONE IN AND IT CHANGES I'M DOING A SPREADSHEET AND WHEN I PUT DATES IN THE COLUMN IT AUTOMATICALLY CHANGES TO A FUTURE DATE. NOT SURE WHAT I'M DOING WRONG ... 21 May 2010 16:08 Help - I've tried all kinds of things but no luck. Howdy, Thanks for taking the time to read my post. I'm having problems creating a custom function in VBA (I'm not an experienced user) Basically i have a huge data sheet with just 6 columns but 60,000 rows. Each of the 6 cells in a row have values (0-10). I need the average of the value in each row, however... 21 May 2010 15:03 Insert an invisible calender only when you click cell in excel ... 21 May 2010 11:43