Search results

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.

Hui! Amazing! Thank you so much for your response. I think that I am missing something or doing something wrong. I am getting and NA on both. It appears that this is occuring when getting the month from N1. I have typed the date in manually and also used the Today() formula. Each time I...

check out: http://www.vbaexpress.com/kb/getarticle.php?kb_id=379

I have a sheet with a column for each month. The column contains both numbers and *. I need to look down that column and show the value for the first cell that does not contain a *, for the current month. (I should mention that cell N1 has the current date) I need another one that will...

I have two rows (B4:M4 and B6:M6) that will often, by design, contain #N/A. All other cells will contain a numeric value. I would like to calculate the average, but each range below may contain NA. B4:M4 = outages B6:M6=unplanned outages I am trying to get the average number of unplanned...

Worked! Thanks again for your help! Appreciate the responses!

Never mind, saw your pevious post with the >1980, I didnt ready Sorry.

They are blank cells and showing up as 1/0/1900, so that when the formula is counting all of the 1 months, it is counting the blank cells. Is there a way to count all of January when the year is greater than 2000, or the day is greater than 0? Completely stuck on this January thing! Thanks...

OK, one more bug. I am also counting all instances of January in column A. This goes back to the blank cells being formatted as dates (1/0/1900). As a result, the formula is counting all of the blank cells as January. Interestingly enough, I can count blank cells and then use that number and...

That worked! Thanks for your help!

I have been able to figure out a formula for all of the months, except January. January is still counting the blank cells as January. Any ideas? Here is my formula for Feb. =SUMPRODUCT(--(TEXT(A6:A126,"mmm")="Feb")*(F5:F125="Y"))