I currently have a cell with the current definition: =COUNTIF(E9:E200,"1000") which yeilded the number of cells that have a value greater than 1000. Now the...

I apologize if you already saw this additional question, because it was buried in the thread after my initial response, but your original solution was so...

I have inherited a HUGE spreadsheet that probably needs to be converted to an Access Database. However, I have been tasked with making the info retrievable...

Hey Mike, Is there any way to make the calendar close automatically once a date is selected? Also, I moved the calendar to another workbook but need to know...

i am using the following formula =J17*H17 the problem is J17 is imported from another file, and that always contains a number value along with some text...

I require a FORMULAE for example if i enter "M" in A1 cell then the B1 cell should display the current time, like this the current time should appear in B2...

I am using a Amortization Schedule template from Microsoft Office online. I am trying to change the Per Period from Monthly - Semi-Monthly etc... to days...

needing a formulas that will count the charcter in a rnage please advise

I netted debits and credits and the answer is zero - it appears - as it should be. However, there are decimal values beginning about decimal place twelve. ...

Hi, I have 3 columns of data. Column x = a list of 130 magazines. Column y = a list of the 45 media owners that own the 130 magazines. Column z = a list of...

I am trying to search for specific words in column A and then print an abbrviated version of those specific words in Column B. There is a set of 7 words that...

I understand from looking at past threads that there is a way to conditionally format a negative percent so that it is red. But why isn't that a choice...

Hi, I have column B which can have a,0,1,sh as its input. I have another column c which can have I,X,D,M as its input. I want to count all the "I" in column...

This formula was working and it no longer works: =IF(D163="Yes","",IF(VLOOKUP(C163,NIRAV,2)="","Not Scheduled",VLOOKUP(C163,NIRAV,2))) I believe it's an...

Using Excel 2003 I have a spreadsheet that tracks errors for 3 departments. 3001 3002 3003 Not sure if you need ALL this info, but I'll give it to you if you...

I can not seem to get the syntax right. =if(AND((A2730,"730),(A2545,A2730,"545-730"),(A2365,A2180,"180-365)))... basically... if 730 then 730 if...

I have a column of values that represent job completion times (i.e. 8:45, 9:26, etc). I am trying to calculate the average completion time excluding the best...

I am concatenating (6) text string cells values into a single/summary cell (H12) on Sheet1 -- then want to display this summary cell value on Sheet2. I am...

i have a detail 20 salespersons' total sales volume on 100 products for Jan to Nov 2008. How do I create a dynamic summary report to sum up the total sales...

Hi Group, I am having trouble with a sumproduct...