Recent content by tpheath

Here is the closest I have been able to get. This works, but I would like to still find a way to get around evaluating each cell for an error, and maybe evaluate them as a whole? =SUM(IFERROR(D57,0),IFERROR(B58,0),IFERROR(R59,0),IFERROR(L60,0),IFERROR(N61,0))

Thanks! Is there any way to do this without having all of the reference cells? While I said that I need to add the same cell in multiple workbooks, I have to do this so many times, that it will take forever for me to do all of the lookups. I will also need to update these periodically, which...

I have 13 different workbooks. I need to sum the sum the values from B54 on the same sheet in each workbook. Some of these workbooks will contain an #N/A error in the cell, others will contain a numeric value. It is not an option to reformat the errors, we do not want to get rid of them. I...

There are 13 workbooks in a folder (that also contains other workbooks and files). I am creating a consolidated workbook and I need to sum the values on the DashboardStats sheet cell B38, from each workbook. I would like to do this with a formula, not VB. I tried...

Was able to figure it out using a different formula. Thanks!

I am currently using the following formulas, but they do not account for ties and I cannot figure out how to account for them so that I don't get duplicate entries in the list that I am creating. For the number =LARGE(N6:N400,1) For the match =INDEX(A6:A400,MATCH(LARGE(N6:N400,1),N6:N400,0))

I need to look down column N6:N400 and find the top ten largest values and display each one. For each top ten result I need to show the value from column A that is in the same row. I need two forumulas: 1. look down column N and find the top ten largest numbers and display each. 2. Look...

Cell H3 contains a date, formated mmm,d,yyyy B23:M23 contains numeric data. I need to copy H3 and B23:M23 to a new sheet titled "Historical" 1. H3 should go in column A on Historical 2. B23:M23 should be entered in the same column name, B-M 3. 1 and 2 from above should be in the same row...

Thank you!!!!!!!

OK, I have played around with the formula and am stuck again. Anyone know how I can use this to get the 2nd, 3rd, 4th, etc values that are >0?

Works great! Thanks. If I want to get the 2nd, 3rd, 4th, entry in the column, which numbers would I change in the formula above?

Hui, Sorry it has taken me so long to respond. I have been out of my office for a while now. Thanks for your effort on this. I will be making those changes! Thanks again

Sorry, give this a try: http://docs.google.com/uc?id=0BxhVKid9p8IBOGE5OGU3NTUtNjA2ZS00NmJlLWE0M2EtZWZlNTE2MDYwMDI4&export=download&authkey=CMvXxYMI&hl=en If this does not work, I could provide me email address, you can email me and I can reply with the document.

I changed the date format to English UK so that the dates were formatted the same. Still had same issue. I have posted the workbook here: http://docs.google.com/leaf?id=0BxhVKid9p8IBOGE5OGU3NTUtNjA2ZS00NmJlLWE0M2EtZWZlNTE2MDYwMDI4&sort=name&layout=list&num=50 The main goal is to look into...

I made the change, but I am getting 0 for both formulas.