Worksheet Functions - Page 659

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
SUMIF Function ? by Joey How do I enter a sumif function to sum cells in column D in the range D3:D216 that match cell H3 criteria using absolute or relative cell references ? Please...	March 17th, 2009 11:16 PM by Gary''s Student	1	50
Force required entry in cell before leaving that cell by Retired Bill In my worksheet, which has several columns, I do NOT want the user to be able to leave a cell in the roll they are working on, UNTIL they have made an entry.	March 17th, 2009 10:57 PM by Gord Dibben	8	67
Count frequence in one column by Excel Sum function with IF[_2_] I am trying to set a formula that will count how many frequency in the column that match the criteria... I have one column that has p, c, and v which means p...	March 17th, 2009 09:44 PM by Elkar	1	45
Email message on cell change event by jknapp1005 I'm trying to figure out a way to send an email to a predetermined list when a value in a cell is less than a certain number. I have the cell conditionally...	March 17th, 2009 09:29 PM by Ron de Bruin	1	62
Vlookup question by zot I'm using VLOOKUP to pull a value from a range if the number in C33 finds a match within that range. Here's the...	March 17th, 2009 09:08 PM by T. Valko	2	61
Sumproduct and Networkdays Together by J_L_G[_2_] I have an Excel 2003 spreadsheet that looks like this: Submit Date Close Date Inspection...	March 17th, 2009 09:00 PM by J_L_G[_2_]	2	57
#DIV/O! Error by Chris I would like to be abe to have the #DIV/O! error show "N/A" when this formula does not find any values to calculate. Due to another program I am using along...	March 17th, 2009 08:42 PM by T. Valko	5	88
Sort not saved across saves/reopens by Kris Okay, I have been using Excel 2007 for about 6 months or so and have run into a really really annoying situation that will cause me to go back to Excel 2003...	March 17th, 2009 08:03 PM by Kris	2	169
#DIV/0 Error by Shane Devenshire Hi, Try =IF(D54=0,0,C54/(4*D54)) -- If this helps, please click the Yes button. Cheers,	March 17th, 2009 08:02 PM by Shane Devenshire	0	58
Formatting Text in cells that already have text entered by Jennifer V. I have approx several thousand cells all with the same info, let's say SSNs. They are in the cell as 123456789. I need to format all cells in this column...	March 17th, 2009 07:44 PM by jb_tenor1	5	56
COUNT IF with multiple conditions by Ghalmaraz Hi, I need a formula to count the number events that occur BY a certain person (in column B, with each person numbered from 1-22), IN a certain category (in...	March 17th, 2009 07:43 PM by Bob Phillips[_2_]	6	48
Sumproduct or Countif - Counting Occurances within a Date Range by J_L_G I have a spreadsheet that looks a little like this: A B C 1 LA 24974 October-08 2 LM 24977 October-08 3 LM 24977 November-08 4 LM 24978 November-08 Colum C...	March 17th, 2009 07:42 PM by J_L_G[_2_]	2	54
Row 1 Deleted by Deborah M I am using Excel in Office 2007 at work. On one Excel sheet I seemed to have deleted row #1, meaning the rows start with number 2. I have tried using the...	March 17th, 2009 07:25 PM by Gord Dibben	3	43
Identifying the # of cells containing data by WA Hello, I have a worksheet with a column that contains 10 vlookup functions (1 in each row). In each cell, the vlookup function displays either a zero, or a...	March 17th, 2009 07:17 PM by WA	3	52
Run time error by ub Hi I have an Excell sheet that I send to diffrent users to complete a task. I have a vba code on workbook open event to hide toolbars and menubar. I code is...	March 17th, 2009 07:05 PM by ub	2	60
Blank Cells showing as 0 in pivot by DLoewenthal I am running a column with an if formula to return "" when false and then when true to return what amounts to an expense ratio. there are cases where the...	March 17th, 2009 06:46 PM by DLoewenthal	1	59
Resolve Conflict error by ub Hi I have a shared workbook currently being shared by 5 users. Each user feeds data from a User form into this shared workbook. Occasionaly, users get a...	March 17th, 2009 06:25 PM by ub	0	66
#DIV/0 Error by Gord Dibben =IF(OR(D5="",D5=0),0,(C5/4)/D5) Gord Dibben MS Excel MVP On Tue, 17 Mar 2009 10:42:05 -0700, Dianne HMM wrote: I...	March 17th, 2009 06:11 PM by Gord Dibben	0	53
#DIV/0 Error by T. Valko Try this: =IF(D54=0,0,(C54/4)/D54) -- Biff Microsoft Excel MVP "Dianne HMM" wrote in message	March 17th, 2009 06:05 PM by T. Valko	0	58
How to control drop down list width by DocBrown This may be a bug... I have cells with validation set to a list. When I display the list, the width of the list is much wider than the column. This does not...	March 17th, 2009 06:03 PM by Gord Dibben	4	265

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed