Adding dates in columns Using 2003, I am entering dates and trying to utilize a formula to calculate the number of cells that fall before a certain date. <"Today()-300", calculates the cells that are in the range. I have tried the countif and sumif formulas, but they do not like ranges within the criteria as noted above. Tried an... 11 Apr 2010 23:26 Non-contiguous range and Sumproduct to average Hi, I'm using the following to average data in K if value in F = value in E5. =SUMPRODUCT((\$F\$52:\$F\$107=\$E\$5)*\$K\$52:\$K\$107)/SUMPRODUCT(--(\$F\$52:\$F\$107=\$E\$5)) I'm intending to use the same formula to calculate averages in columns I to N in about 45 sheets all with the same layout and different data. Column ... 12 Apr 2010 22:34 Find 2 lowest point to form a trendline Dear expert, Cell AH67:AH77 contain a series of data. Actaully, they are the results from an array of formula. Sometimes, it has 12 data. Sometimes, the data series has 8 data like this case. The question is that ... I would like to find 2 lowest point so that I can draw a line to form like a trendline (usi... 11 Apr 2010 11:16 date Concatenation Hi, I am trying to date Concatenate 2 cells. One contains text the other date. How can I get the date to display as a date? =T6&" "&U6 returns ESTIMATE 40066 ... 11 Apr 2010 10:09 Delete 3 end row Hi I want to delete three end row of any sheet. any sheet has different row number. Thank's for any help. your's ... 11 Apr 2010 06:54 Removing multiple duplicate events Hi I have a spreadsheet that has a complete address in one column (a) In column (b) (B1:B165) I have the name of the suburbs I wish to remove from col (a) Start Col (A) 15 Smith Street Blacktown Col (B7) contains the suburb Blacktown (I have 165 suburbs in this column) I want to remove that same data f... 13 Apr 2010 07:17 Unprotect problem How do I unprotect a worksheet in Excel 2007 when "unprotect sheet" is greyed out? (I have matching problem with protecting.) ... 11 Apr 2010 04:45 Alternative of Vlookup Thanks! Great Work!!Excellent!!! Vlookup has shortcoming and it would realy overcome that shortcoming. I was looking it several time and did not get it. Then I used VBA and succeed but I wanted functions. Would you please explain TOTAL FUNCTIONS, specially Max(B2:E4=10)? T. Valko wrote: Try this... 11 Apr 2010 02:38 Customize accounting format I've been banging my head on my desk for two days over this problem! I want to customize the accounting format to show 0 as: \$ 0.00 (with a \$ to the far left of the cell and 0.00 to the far right. What symbol/space/other thing do I use to create this extra space? -- AAAaaarrrgggaaah! It's only 5 da... 10 Apr 2010 23:24 Freeze Column In Microsoft 2007, I usually do this. In the 'View' tab, select "Split." A bar will appear in the middle which can be moved left or right. This will create a duplicate of your spreadsheet. BUT WAIT! It's not a regular copy. If you make an edit on one side, the edit automatically edits the other side. ... 11 Apr 2010 07:58