How do I find the minimum value in a range while ignoring zeros? -- How do I find the minimum value in a range while ignoring any zeros in that range using Excel 2007? ... 5 Apr 2010 23:56 Automatic Sumning of Same Cell from Different Sheets I'm having difficulty creating a formula that will automatically add the figures in cell C8 on the current sheet, plus the next 3 sheets. I need cell C8 to remain static, but the current sheet and next 3 sheets to change according to whichever sheet I use that formula in. For example, A formula where it sums ... 8 Apr 2010 19:43 Trying to calculate # of times text string is displayed I have a worksheet where I track what I've applied the number to; i.e. acct # in column A and user type in column E (nanny, sitter). I'd like to use a function to calculate how many rows are classified as "nanny" or "sitter". The outcome I'm looking for is the same as if I go Ctrl+F, "Nanny", Find All which g... 5 Apr 2010 18:23 Match Account ID from combining street names and numbers In one sheet, have a column with a street number (A): 115 in Column B, have a street name: Northwest. In workbook 2, have an additional street number column(C), and a street name column(D), and a 5th column with an account number, column (E) I need to find the account number in workbook 2 for a combination of s... 5 Apr 2010 17:16 Date Format I have the following formula in cell A9: ="NDTMTASME001Q-"&BC69&"-"&AG13 which returns: NDTMTASME001Q-40273-1626, however, the 40273 is not correct. I would like it to be 040510. I have a date in cell N18 formatted as mm/dd/yyyy (04/05/2010), then I have cell BC69 set to equal N18, but in the mmddyy (0405... 5 Apr 2010 17:16 calculate diffence between old salary and new salary I have to figure out the impact if a daily salary increases. How do you calculate the difference ex: \$100/day to \$200/day, what is the impact on annual increase? ... 6 Apr 2010 11:56 Need help with ISNA, INDEX, MATCH I am trying to write a formula using the ISNA for finding the name to an ID. In Sheet 1 cell E2, I tried the following formula...=IF(D2>0,INDEX(Sheet2!A:F,MATCH('Sheet1'!D2,Sheet2!A:A,0),6),"") On Sheet 2 the ID is in column A but I need the name of the ID that is found in column F. If the ID in column D on ... 5 Apr 2010 17:16 copy excel spread sheet & graph to word doc without formulas I have an excel spread sheet which includes a graph I made from the spreadsheet. I would like to copy both to a word document but I don't want any reference to the formulas or vlaues. how do I do this ... 5 Apr 2010 16:08 VLOOKUP & Hyperlinks I would like to use VLOOKUP to copy a hyperlink from another spreadsheet. Is this possible? Currently, when I do the VLOOKUP, it only copies the display data, not the hyperlink. ... 5 Apr 2010 15:01 Using multiple IF statements I am trying to create a formula using multiple IF statements. Individually they all work but I don't know how to connect them in into one formula. Basically, 4 possible date ranges that would each produce a different text value. Any suggestions? =IF(AND(I1>=DATEVALUE("1-Jan"),I1<=DATEVALUE("31-Mar")),"Sprin... 5 Apr 2010 12:46