Worksheet Functions - Page 542

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 do I count the sum of 2 columns in excel? countif(a1:a100='op. by Bruce I am having trouble with the syntax here nested functions - this is what I am attempting to do countif(a1:a100='open' and b1:b100='i')	February 21st, 2005 03:20 PM by JE McGimpsey	1	86
Find last non-blank row with a worksheet function by Bruce Find the last row with a value. Say I have a worksheet with a data entery range of A1 to A100. The user is required to enter data from row 1 downwards and...	November 25th, 2005 05:10 AM by Bruce	2	101
Help me help a user in our office by Bruce Assume the listing of data below: Num Name Tx Ok Ks 1 Smith 10 15 18 2 Jones 12 14 16 3 Brown 82 500 65 4 White 111 80 60 5 Pinkerton 75 65 55	December 7th, 2005 04:49 PM by Bob Phillips	5	98
Run macro based on time by Bruce I am using a work sheet that links by DDE to a machine PLC. It is updating once a second. I have a time of day clock built into the sheed. How can I run a...	December 23rd, 2005 01:27 PM by Bruce	7	147
Projecting sales dollars based on actual history by Bruce I am trying to set up a sheet that will use my actual sales figures from the last two years to project what this years sales might be. I have set up the table...	January 14th, 2006 07:49 PM by Bruce	2	86
Calc RSQ and exclude zeros by Bruce I want to do an array formula for the RSQ function so that it excludes zero values in the calc.. The RSQ has 2 arguments, 1st for y's and 2nd for x's. My...	January 19th, 2006 01:01 PM by vezerid	3	66
rounding values in in array before sum by Bruce Hi, Anyone know how to round each cell before summing the data. For example, I have data from A1:A10. If I sum the data and then round...	January 31st, 2006 10:06 AM by Bruce	4	102
Having to key the equal sign to start a formula by Bruce Is there a shortcut key in excel that you could skip having to type the equal sign (=) before the mathematical operation you want in a cell? In other words,...	February 8th, 2006 06:03 PM by Paul B	1	77
how to use * wildcard in a sum(if((cond),range)) array formula by Bruce Hi, Can anyone tell me howcome the * wildcard does not work in my sum if array formula. I realise that it will work with the standard SUMIF function but I...	February 10th, 2006 01:29 AM by RagDyer	3	116
Is there a logical test for a cell's format instead of contents by Bruce Microsoft Excel 2003 I have a list of names for a roster in a single column covering several months. The information is imported from another source (MS...	November 17th, 2005 01:40 AM by Gord Dibben	3	151
dynamic summed range based on a variable by Bruce I want to sum a dynamic range based on a value (myValue). The idea behind this is as myValue changes so will the range summed. The formula will first get the...	November 8th, 2005 02:45 AM by Peo Sjoblom	3	123
Countif < than var1 and > var2 by Bruce How do i do a Countif than var1 and var2? eg. Countif var1 =COUNTIF($T:$T,"" & $C2) I have tried Countif var1 AND var2...	April 15th, 2005 02:48 PM by Bernie Deitrick	1	86
Date Calculations by Bruce Hope I can explain this clearly. If this, or something like it, has been answered before, please direct me to the post. I have a worksheet in which I need to... ( 1 2)	May 19th, 2005 01:09 AM by Bruce	11	839
Calculate the CAGR by Bruce How can you calculate the CAGR (Compounded Annual Growth Rate)? Say I have 2 numbers and corresponding dates as follows; 1999 - $10000 2003 - $25000 How...	June 7th, 2005 02:17 PM by Niek Otten	6	146
find * by Bruce Using find in Excel, how can I search for * as a chanracter instead of it thinking its a wildcard? Bruce	June 14th, 2005 07:16 AM by Biff	2	128
how can i calc averageif by Bruce How could I calc an averageif in a similar way to the sumif function? i.e. Average if A2 = B2 from C2 Bruce	June 18th, 2005 02:08 PM by Dave Peterson	3	91
Sumif with a twist? by Bruce 43975000 50 43865000 100 43828000 5 43828001 21 Assume the block of data above, and that I want to do a sumif formula, with the range being the 1st column,...	August 16th, 2005 10:57 PM by Aladin Akyurek	1	49
How do I change all cells to Proper text in Excel by Bruce I have followed previous postings but I am getting Circular reference errors when I try to perform the fucntion on the cell I am trying to change.	October 4th, 2005 05:11 PM by David Billigmeier	1	98
Countif array formula by Bruce I have the following formula to count values greater than zero. =COUNTIF('Product Sales'!$H$4:$H$1000, "" & 0) I want to change it so that if the sum of the...	October 14th, 2005 08:46 AM by Bob Phillips	1	85
Countif unique by Bruce How do i count unique values in my data? Eg A1:A5 Red Blue Yellow Blue Red =3	March 1st, 2006 11:06 AM by Bob Phillips	3	86

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