Worksheet Functions - Page 521

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
How sum values in column B using values in column A as the conditi by oldgrayelf I want to sum the values in column B using indicators in column A as the condition. For instance, all values in column B matching the "1" indicator in column...	February 4th, 2005 09:03 PM by oldgrayelf	5	305
How do I insert the directory path in my Excel file? by Insert a Directory Path in Header/Footer I have Windows XP operating sys and Excel 2000 version. I am trying to insert my directory path in my Excel document. In older versions of Excel and other...	February 4th, 2005 09:23 PM by Nicole L.	2	247
CELL("FILENAME") by JEV Iâ€™ve used CELL(â€˜FILENAMEâ€™) on two different workbooks which are now used as templates. Both files are open. Each time I use SAVE AS to create a new...	February 4th, 2005 10:25 PM by JEV	4	112
if formula = negative #, then insert a word by Nicole L. I have a cell (G1) that is the sum or some other calculation of other cells (SUM(C1:F1))... What formula do I use to say that IF that calculation turns out to... ( 1 2)	February 4th, 2005 10:34 PM by Gord Dibben	10	270
ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL by lost in translation I am trying to sdd the columns across for a grand total, how can I do this?	February 4th, 2005 10:40 PM by Gord Dibben	2	143
Formula Help (new to Spreadsheet) by Ken Moskowitz I am trying to calulate a field that represents money due in 30 days. I need a formula that will essentially look at... if there is a balance due that is...	February 4th, 2005 10:41 PM by Ken Moskowitz	0	79
Logical Function - Multiple IF statements by vnsrod2000 Can anyone help me figure out a formula for the following sliding bonus scenario: To receive a bonus, Gross Profit must be at least $250,000 Once minimum is...	February 4th, 2005 10:42 PM by JE McGimpsey	7	195
autofilling cells by Tim I have a long list of automobiles in many different spread sheets. I have all these cars numbered! I want to be able to make a work order sheet that the first...	February 4th, 2005 11:10 PM by Gord Dibben	1	72
possible to have =now() at data entry and not update after that? by .:mmac:. How can I set a cell to contain the =NOW() date only once when data is entered in the adjacent cells and not have it update after that? Right now I copy from a...	February 5th, 2005 12:43 AM by Peo Sjoblom	5	123
Array Functions from Alan Beban by Josh O. I need so quick assistance. I downloaded the functions in the freely downloadable file at http://home.pacbell.net. But I don't know how to make them... ( 1 2)	February 5th, 2005 12:54 AM by Harlan Grove	13	795
Can't find logical_test for "if"statement by John Grossman I have two possible entries in column A: http://www.amazon.com/exec/obidos/tg/detail/-/0934419345/ or http://www.amazon.com/exec/obidos/ASIN/0439784549/ My...	February 5th, 2005 04:34 AM by Peo Sjoblom	1	98
Formula Help (new to Spreadsheet) by Ken Moskowitz The problem is I need a DOLLAR figure for money due in 30 days (T3) (a dynamic field) that is calculated off of balance due (I2) that have a balance due date...	February 5th, 2005 06:32 AM by Bob Phillips	4	82
Finding and Deleting duplicates in a column by Brian I have a huge list of 10 digit numbers in column B. These numbers where scanned in using hand-held barcode scans, so human error is possible. I may have...	February 5th, 2005 02:19 PM by Brian	3	334
Copy a column in worksheet with a character change by photowiz HI Is there a way to copy the contents of one column to another, but change say the fifth character of each cell to a different character? For instance, I have...	February 5th, 2005 03:35 PM by Ken Wright	1	365
Number of records by Month that meet a specific requirement by Keith Brown I have been working on a spreadsheet for the last few days, making it much better for the end user with all of your help with functions. Now that I have Excel...	February 5th, 2005 05:42 PM by Peo Sjoblom	1	242
How to add amounts from different worksheets to one single worksh. by cgw Just want to know, am new at this multi worksheet ( 1 2)	February 5th, 2005 05:54 PM by JulieD	10	238
Using IF and SUMPRODUCT?? by Joe Gieder First, Thank you for your help and all the help you have given. I have this...	February 5th, 2005 08:47 PM by Joe Gieder	4	80
Excel formula by Mike I want to find the highest number in a column and display the name in the column to the left of the highest number -- thanks Mike	February 5th, 2005 10:46 PM by Aladin Akyurek	2	77
using vlookup - how do I match 2 spreadsheets w/o same exact numb. by klondike47 I have 2 spreadsheets. 1 is my customers inventory and Year To Date sales the other is my West Coast sales history. His spreadsheet does not have all of the...	February 5th, 2005 11:01 PM by John Mansfield	1	197
HOW DO I USE THE COUNT IF FUNCTION FOR 2 CRITERIA by victory16	February 5th, 2005 11:39 PM by tjtjjtjt	1	98

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