Average with Condition I have a report sheet where Cell b10 represent the day of the month I need a formula that will look to a prior month sheet for the corresponding day as identified in B10 and average the sum sales to that point In the source sheet Column B (rows 9 thru 39) = day of month Column AE (row 9 thru 39) = sales... 18 Mar 2010 15:31 Moving cell formula I have a formula that calculates averages each week. I need a formula that automatically uses the cell below when new data is entered. ... 17 Mar 2010 15:58 How to combine data from 2 separate workbooks onto 1 worksheet I am planning a meeting for 100 attendees. Our database contains a unique ID for each attendee as well as their name, mailing address, phone number, etc. I have another database that I received from our Travel Department containing the airline information (arrival date, arrival time, flight number, arrival ai... 17 Mar 2010 15:58 Print to file Excel won't let me print. When I try to print, it automatically comes up with "Print to file" and when I press cancel, it cancels everything. Print to file is not selected on the print page but it keeps doing this and I can"t get around it. ... 17 Mar 2010 17:26 Add comment in protected worksheet Can we add a comment for cells in a protected worksheet. I wanted to allow feature to only add comment and not allow user to do any other modifications ... 17 Mar 2010 14:47 Excel 2007: Conditional Formatting and Ribbon Data I have several cells have conditional formatting equations which refer to a date value in cell H1 (for example). I want to be able to move the value stored on this cell to a control on a Ribbon. 1) Is it possible to put a Date Picker control on a Ribbon? 2) Is it possible to refer to the value of this or any othe... 17 Mar 2010 14:47 Microsoft Excel Total Values I have multiple instances on my spreadsheet of the same part number that I am tracking. In the differernt lines I have the different quantities of the same part number. I want to ultimately pull them together to get a TOTAL, how do I do this? ... 17 Mar 2010 20:00 Summing Cells with Text and Numbers > ... It doesn't seem to work, if 1 of the cells in the array is blank... is there a way of putting in a condition where it ignores the blank cells? Try this variant, array-enter (press CTRL+SHIFT+ENTER): =SUM(IF(NOT(ISBLANK(A1:D1)),IF(LEFT(A1:D1,1)="S",RIGHT(A1:D1,LEN(A1:D1)-1)+0))) ---- Max Singap... 17 Mar 2010 12:31 Insert Picture Can I insert a picture into a cell? How? ... 17 Mar 2010 14:47 leave sum of j7 at 40 or less put excess in k7 ... 17 Mar 2010 15:58