Functions

@Count
I am using Excel 2003. How do I count rows/column with only text in it. Ex: I have 25 rows where column "B" says "PO Received" in each cell. I tried @count(B1-B24), but I only came up with "0" as an answer. What am I doing wrong? Can anyone help me with this, please??? Aurora ... 7 Apr 2010 15:47

What is the most straightforward (elegant) way to write this formu
Glenn wrote: ewillig wrote: Rows = projects and Columns = components needed for this project. I am looking to make 2 calculations on each project. The first is the overall time required for this project based upon the components required for this project and the second is the balance of time ... 7 Apr 2010 13:32

Why won't text show in SOME cells?
I have the following text formatted as Word Wrap, Text, Top Align, Left Align, but all I get in cell is ############. This has worked in other cells in the same column. Please let me know ASAP what else I need to change--I'm on deadline for a project. Thanks! Next Step: Get more current information to gree... 7 Apr 2010 15:47

What is the most straightforward (elegant) way to write thisformu
ewillig wrote: Rows = projects and Columns = components needed for this project. I am looking to make 2 calculations on each project. The first is the overall time required for this project based upon the components required for this project and the second is the balance of time required to complete it... 7 Apr 2010 13:32

speeding up calculation: replacing array formula with database function?
Assuming you data is sorted (or can be sorted) on column A and starts in Row 2 then you don't need array formulas: in column C (or somewhere suitable) add a helper column containing =IF(A2<>A1,COUNTIF(A:A,"="&A2),0) and fill down in Column D put =IF(C2>0,MAX(OFFSET(B2,0,0,C2,1)),D1) and fill down If you ca... 7 Apr 2010 13:32

What is the most straightforward (elegant) way to write this formu
Rows = projects and Columns = components needed for this project. I am looking to make 2 calculations on each project. The first is the overall time required for this project based upon the components required for this project and the second is the balance of time required to complete it. In row 2 I have a s... 7 Apr 2010 13:32

Countifs
Hi All, New in Excel 2007. Why is Countifs giving an error when I try to enter it with combined formulas like: =countifs(month(range);1;other_range;1) With kind regards, JP ... 8 Apr 2010 23:05

editing a hyperlink
I have a stock symbol MED in A1. In A2 I have inserted the following link: http://www.investors.com/StockResearch/StockCheckup.aspx?symbol= I want to concatenate the symbol in A1 into the hyper link in A2 like shown below so that the link will show the data for the stock symbol MED. http://www.investors.com... 7 Apr 2010 12:23

IF equation will not calculate
I have the following equation: =IF(J12="Prospecting",X12,"") and this is odd: 1. Prospoecting is taken from a pulldonw list. 2. I just abbreviated the word Prospecting to one word from its original 3 with parenthesis. 3. The exact equation is used on 6 or so other pulldown options with no issues. 4. I know ... 7 Apr 2010 11:14

Remove Arrow
Dear Expert, Got system generated files ... <.HSI> <0941.HK> <2828.HK> Is there any functions that can let me capture the content only? That is no "<" and ">" ... Thanks Elton ... 7 Apr 2010 12:23