Formula Help I need a formula that will take A1 x B1 but if the number is less then 0 it will only how up as 0 and if its more then 0 if will show up as the real number. ... 28 Apr 2010 16:20 Average IFS (Multiple Criteria) I have been using the following SUMIFS funtion that works perfectly, but need to average a column of %. Is ther esucha thing as AVERAGEIFS that will work with multiple criteria? =SUMIFS(AF\$4:AF\$169,\$G\$4:\$G\$169,\$G174,\$F\$4:\$F\$169,\$F174,\$J\$4:\$J\$169,"<=12/31/10",\$J\$4:\$J\$169,">=01/01/10") ... 28 Apr 2010 18:37 Possible to have various sections of worksheets print on 1 page? Excel question Because of drastic formatting differences in a document, I've created sections of a document on 3 worksheets. On the first page of the print-out I need all three sections to print on page 1. Is it possible to do this in excel and how? Thanks for your help. -- Respite Barb ... 28 Apr 2010 15:11 Average IFS (Multiple Criteria) I have used the following formula and it works perfectly, however, one column is % and I want to get an average of the %'s with the same criteria. Can this be done? Basically, is there and AVERAGEIFS function? =SUMIFS(AT\$4:AT\$169,\$G\$4:\$G\$169,\$G174,\$F\$4:\$F\$169,\$F174,\$J\$4:\$J\$169,"<=12/31/10",\$J\$4:\$J\$169,">=01/0... 28 Apr 2010 14:02 Pull info from one excel file to another depending on values of O. I need the formula that can transfer rows based on a > value of a cell in a row into a different excel file. For example: Part# Jan Mar Oct Total Avg 1st QtrAvg 2nd QtrAvg 3rd QtrAvg 4th Qtr Avg 913 3 1 1 5 1.6 1.3 0.00 0.00 .... 28 Apr 2010 14:02 Index Match Problem I'm using the following formula, but it's returning #N/A: =INDEX('File X'!\$F\$1:\$F\$2000,MATCH(1,(\$B5='File X'!\$A\$1:\$A\$2000)*(S\$4='File X'!\$G\$1:\$G\$2000),0) However, if I replace the S\$4 with "7710", it returns the correct value. The number in S4 is 7710. Why won't the formula recognize the cell reference, b... 29 Apr 2010 02:25 Pivot Table Comparison Hi all, I am hoping t get some help on this. I have two worksheets of monthly data (last month and current month) that gets updated at the end of each fiscal month. I pull the data into two pivot tables on the third sheet and am trying to put a formula together to compare the pivot table data. Here is an ex... 28 Apr 2010 20:53 Drop Down Menu I am having trouble with the drop down menu, I create a list called operations hit enter and then choose a cell like the instructions suggest, choose the list and hit save and I get my comments to show up but no drop down arrow, can someone help me? -- Best Regards Alan D "Can''t Cache Me" wrote:... 28 Apr 2010 15:11 How do I get warpped data to auto fit in merged cells? I'm developing a survey form. I want to ask a quesiton and the use four merged cells to the right of the question to record the answer. I also want the height of the row to automatically grow if the text exceeds the field lenght. The only way I see that happening is for just individual cells. Can I make the... 28 Apr 2010 17:29 Deleting/Clearing duplicate range of cells Below is my data. If a row range of cells is identical to another, could a macro be written to find the duplicated rows, and clear those cells ? As follows: M3:R3 no duplicate, so keep M3:R3 M4:R4 identical to M5:R5, so delete/clear M5:R5 M6:R6 identical to M7:R7, so delete/clear M7:R7 M8:R8 identical to M9:R9... 29 Apr 2010 15:49