Worksheet Functions | Forum profile

Array entered =SUM(IF(Chart1!$AZ$2:$AZ$10000"",IF(Chart1!$AZ$2 :$AZ$10000=0, Chart1!$F$2:$F$10000))) If this post helps click Yes --------------- Jacob Skaria "bob" wrote: Column AZ contains cells that are either zero or are blank (meaning no value has been entered in the cell). The formula below is referencing the blank cells as zeroes. But I only want it to reference the cells that have zero in them. How...

=AND(COUNT($C4,$F4)=2,$C4100%,$F41) why the AND? Because we're testing for multiple conditions and they *all* must be TRUE for the format to be applied. First we check to make sure there are in fact numbers entered in the 2 cells: COUNT($C4,$F4)=2 = TRUE or FALSE If both cells were empty then: $C4100% = TRUE $F41 = TRUE And in that case the format would be applied but I'm pretty sure that is not what the OP wants to happen. So, with...

Hi, in Excel 2007, you can filter the column by colour and then use the SUBTOTAL(9,range) function. This will sum up the coloured cells. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Atomic" wrote in message ... I have a chart and want to know how I can get the sum of coloured cell? Is there a macro or a function where I can do that? i.e I have Cells C3:R3 and (cells E3, H3, I3,J3 and N3 is coloured ) I...

Try =INDEX(Sheet2!A:A,MATCH(C1&"*",Sheet2!A:A,0)) 'error handled =IF(ISNA(MATCH(C1&"*",Sheet2!A:A,0)),"", INDEX(Sheet2!A:A,MATCH(C1&"*",Sheet2!A:A,0))) If this post helps click Yes --------------- Jacob Skaria "jtoy" wrote: I realize the formula solution is probably not a vlookup function, but I'm trying combinations of...

This seems to work: =LEFT(A1,LEN(A1)-3)&(RIGHT(TEXT(A1,"0"),3))+23 HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "MMangen" wrote: I'm not quite sure how to best describe this: I need a formula that will take the example below and return the "final result" Col. A = 24.43.234.555 and Col B= 23 making Final...

CF/ Formula is: =AND($C4100,$F41) As a matter of interest, did you actually intend DAYS360, or could you have used =E4-TODAY() ? -- David Biddulph "Bullocks" wrote in message ... Good day, Hoping someone can help… In cell C4 I have percentage In cell E4 I have a due date In cell F4 I have calculated the number of days something is overdue using this formula: =DAYS360(TODAY(),E4) What I would like to be able to do, is...

Thanks Bernard -- Gary''s Student - gsnu200909 "Bernard Liengme" wrote: I played around with ERROR.TYPE which (fittingly!) has some 'errors' of its own (see http://support.microsoft.com/kb/213891 ) In C1 enter this formula =IF(ISERROR(A1),CHOOSE(ERROR.TYPE(A1),"e1","e2","e...

You're welcome. Having a separate table for errors makes the problem easier to handle. Pete On Nov 27, 6:40*pm, Gary''s Student wrote: Thanks Pete -- Gary''s Student - gsnu200909 "Pete_UK" wrote: I picked out the table entries which had errors in column A and put them lower down starting in A12, like this: #DIV0! * * * *Rocky * * * * * * *2 #N/A * * * * * *Bullwinkle * * *7 #NAME? * * Natasha * * * *...

You can use wildcards with VLOOKUP, so try this: =VLOOKUP(Sheet1!C2&"*",Sheet2!A:A,1,0) Hope this helps. Pete On Nov 18, 5:01*pm, jtoy wrote: I realize the formula solution is probably not a vlookup function, but I'm trying combinations of MATCH, SEARCH, ISNUMBER, INDEX, and still not getting the right result. I've got 2 worksheets. Worksheet 1, column C has a 15-digit ID like 02i40000001fpv0. Worksheet 2,...

Hi, If you wish, you may mail the file to me at ask(at)ashishmathur(dot)com. Please mail a small file I.e. mail the relevant information only. Also, please state the question clearly. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Ashish Mathur" wrote in message ... Hi, Click on OK on that box -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "jem-jems" wrote in message...