Functions

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