Count function seeing formulas as data - 93600

How can you get around the count  function seeing formulas in any cell 
referenced as data?
0
Utf
6/6/2010 10:54:03 AM
excel.worksheet.functions 4936 articles. 2 followers. Follow

4 Replies
869 Views

Similar Articles

[PageSpeed] 27

I don't think COUNT will, COUNT yes, but not COUNT unless it returns a 
number.

Give an example.

-- 

HTH

Bob

"robinessex" <robinessex@discussions.microsoft.com> wrote in message 
news:A729CA67-E421-49C1-8850-7E9AA24D0DE8@microsoft.com...
> How can you get around the count  function seeing formulas in any cell
> referenced as data? 


0
Bob
6/6/2010 11:51:00 AM
Hi,

I don't understand the question. Perhaps if you tell us what you are trying 
to count and the types of data in the cells being counted someone will help.
-- 
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that 
introduces the fewest assumptions while still sufficiently answering the 
question.


"robinessex" wrote:

> How can you get around the count  function seeing formulas in any cell 
> referenced as data?
0
Utf
6/6/2010 11:59:21 AM
I'm sure Bob meant =CountA() will count cells with formulas.

=Count() will count cells with formulas if the formulas evaluate to a number.

Bob Phillips wrote:
> 
> I don't think COUNT will, COUNT yes, but not COUNT unless it returns a
> number.
> 
> Give an example.
> 
> --
> 
> HTH
> 
> Bob
> 
> "robinessex" <robinessex@discussions.microsoft.com> wrote in message
> news:A729CA67-E421-49C1-8850-7E9AA24D0DE8@microsoft.com...
> > How can you get around the count  function seeing formulas in any cell
> > referenced as data?

-- 

Dave Peterson
0
Dave
6/6/2010 12:40:28 PM
On Sun, 6 Jun 2010 03:54:03 -0700, robinessex
<robinessex@discussions.microsoft.com> wrote:

>How can you get around the count  function seeing formulas in any cell 
>referenced as data?

You misunderstand the COUNT function.  It only sees "formulas" as data
if the formula returns a numeric value.

If you could be more specific as to what you are trying to do, you
might get some useful advice.
0
Ron
6/6/2010 3:10:18 PM
Reply:

Similar Artilces:

How to I incorporate SD from a data series into chart error bars?
I have means of values that are in a line chart. I want to add error bars, however when I add the error bars with SD=1 they all look the same. I know the SD for each mean is not the same. I want to know how to get the error bars to represent the SD of the data set (the set from which the mean was derived) and not all look the same. Set the 'Error amount' option to 'Custom' and specify the range in your worksheet that has the SDs. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In ar...

grade sheet formula
im a teenager trying to do a project for school on excel. i need to re-do my grade history sheet on excel. this is fine, i've done it all, and i'm fine on that part. where i'm lost at is the points part. the thing is for every class i have a grade. for every grade there are points (A=4, B=3, C=2, D=1, F=0). that and also, if one of my classes is honors gifted, a bit higher in level, you get an extra point (A=5, B=4, C=3, D=2, F=1). and if you're in an AP class, advanced placement, it's 2 more points (A=6, etc.). what i need to know is a formula so that whatever grade...

Pivot table and counting.
I have a pivot table that gives me the number of rides done by a van. I can have the pivot table return the number of rides, but what I need is the number vans that participated for a certain day. Example, it is possible to have 27 trips done by 18 vans, how can I count the number of vans and not addup the van number? Any help appreciated. Thank you, Joe Hi Joe We need a bit more information on how your source data table is set up. What information do you have in each column? -- Regards Roger Govier sacredarms <sacredarms@discussions.microsoft.com> wrote: > I have a pi...

Outlook Data Collection for A2007
I am trying to set up data collection. Outlook and Access 2007 While in Access I get message: The Microsoft Office Access Outlook Add-in is disabled in Microsoft Office Outlook 2007....verify that it is installed....... I am looking for the file name so that I can locate the Add-in. Thanks. Found it........accolk.dll "Tom Ventouris" <tom@pmads.coza> wrote in message news:uiCEP$oYIHA.4180@TK2MSFTNGP06.phx.gbl... >I am trying to set up data collection. Outlook and Access 2007 > While in Access I get message: > The Microsoft Office Access Outlook Add-in is disab...

comparing data #2
I was wondering is there a way to compare data from 2 columns in a side by side comparison. I have a large list of numbers and what I want to do is copy another list of numbers into the spreadsheet. But I want the numbers in cell A1 and B1 to be equal if they are is not a match then leave cell b1 empty. I want that to continue all the way through the entire worksheet. Maurice, Do you want to end up with 2 separate columns, or are you wanting to merge the 2 lists into 1 list, without duplications? Dave I want 2 side by side columns. With the numbers that are equal right next to each othe...

Cycle Counting
Hello, I am looking for ideas on how to cycle count serial number tracked items without increasing workload. Our serialized items are barcoded but the problem is the are situated on the pallet incorrectly and the pallet is placed on a third level of a racking system. If we could just cycle count based on item count and not include the serial number it would make it easy. Is this possible in Great Plains. We are running Great Plains 8.0. Any suggestions are greatly aprreciated. Thank You, Brian Morris Database Administrator ...

Count
Hi, I would like to know how which formula I should use to count some codes & to ignore the duplicated codes, for example in column A: Code 1234 4321 4321 1234 1234 3214 Now, I want Excel to count & the result is 3 which are: 1234-4321-3214 Yes I can use PivotTable, but I would like to use a formula because I have to deal with this every day. I appreciate your support. -- MFS22 COUNTIF will do it. =COUNTIF(Rng,Rng), where the criterion is the same as the range: e.g =COUNTIF(A3:A8,A3:A8) HTH Peter "MFS" wrote: > Hi, > I wo...

Problem importing data to Money 2006
I'm importing data from Money 2000 into 2006 and the dates and quantities of investment transactions are not transferred. I exported multiple accounts within a file with File/Export and changed the file names to reflect the account names (with .qif after them) to a removable flash drive. Followed import instructions (File/Import), set up multiple accounts and moved them as a group. The transfer appeared to be successful except date and quantities were not present. Any ideas? -- leahn In microsoft.public.money, leahn wrote: >I'm importing data from Money 2000 into 2...

How to see all recipients in email header?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Greetings <br><br>When I receive an email with more than a few recipients in the To: filed (or Cc: for that matter) Entourage decides to truncate the list of addresses viewable at some point. It then puts &quot;...&quot; which when moused-over pops up with how many other recipients there are. But at no time am I able to view them! I have sifted through preferences, views, and searched this forum and the internet. Every email program I have EVER used allows this sort of option except Entou...

Looking for Macro to load data from Access table
I need to code a button to delete data in a spreadsheet then reload the data from an Access table. I'm a new excel user so I down know where to start. Thanks Maybe this will help http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Randy K" <wawork@hotmail.com> wrote in message news:43ff7bea.3595531@msnews.microsoft.com... >I need to code a button to delete data in a spreadsheet then reload > the data from an Access table. I'm a new excel user so I down know > where to start. > > Thanks ...

How do I count the # of times a value reoccurs and plot it over ti
I wish to plot a number of errors made by each users and compare it over time. I have a column of user ID's and a column of dates. I want the chart to count the number of times each user ID appears and plot against it's corresponding date. However, each time I try to do this, the chart appears wrong. Any ideas? In article <9595B2A1-8282-4AB3-8511-A6776E108164@microsoft.com>, Stephen@discussions.microsoft.com says... > I wish to plot a number of errors made by each users and compare it over > time. I have a column of user ID's and a column of dates. I want t...

Line count
I am working with a program called Dictaphone. We use Word 2007 in this program. The line count on Dictaphone and the line count in Word 2007 are different even though the Dictaphone text is retrieved from Word 2007. Why would they be different? What is the difference between virutal line count and physical line count? ...

Data Consolidate Limitation
Hi, Consolidate function is useful for budgetary consolidation purpose However, if there are > 12 worksheets to be consolidated, then consolidate function is unable to call back and consolidate say 45 worksheets as it has reached the max limit of consolidation ( ie 12 sheets ) In this case, is there any options/alternatives available either on excel function or excel vba to solve this problem ? Thanks & Regards Len Can you just run cosolidate on 12 sheets at a time. I have written very simple macros (about 30 lines) that can consolidate unlimited number of sheets...

Is there any way to use longer strings in formulas?
In Excel 2002, the longest string I can use in a formula is (to my mind) ludicrously short. I have a workbook that requires HUNDREDS of English sentences like: ="Just to let y'all know, thanks to all the swell work by our sales staff in 2007, and despite our having to fire half of them for insubordination, and despite our chairman's having run off to a region in Asia which we believe is officially called the Glorious Former Soviet Autonomous People's Provisional Revolutionary Socialist Republic of Trans-Caucasian Equitorial Guinea, our company's annual return on investme...

not calculating formulas
in some excel sheets, after a while it stops calculating formulas. if i copy the hole sheet and paste it into another, everything works fine. Any chance that on the: tools|options|Calculation tab| calculation was set to manual? doros wrote: > > in some excel sheets, after a while it stops calculating formulas. if i copy > the hole sheet and paste it into another, everything works fine. -- Dave Peterson No. I have allready checked that. "Dave Peterson" wrote: > Any chance that on the: > tools|options|Calculation tab| > calculation was set to manual? > &...

count number of characters in rich edit control
How can i count number of characters in rich edit control 2 If u mean controls of type Rich TextBox control, try RichControl1 RC1; CString Mes=RC.GetText(); int n=Mes.GetLength(); "Rahul" <Rahul@discussions.microsoft.com> wrote in message news:7743023C-EA83-4ACA-AB67-F1AE7279F1EB@microsoft.com... > How can i count number of characters in rich edit control 2 EM_GETTEXTLENGTHEX, WM_GETTEXTLENGTH, WM_GETTEXT, EM_STREAM* "Rahul" <Rahul@discussions.microsoft.com> wrote in message news:7743023C-EA83-4ACA-AB67-F1AE7279F1EB@microsoft.com... > How can i co...

Share Calendar and see other users Appointments
Hi, It is probably a rookie question but i hope that someone has mercy and answers this with some tips or pointers to assist me to make this work. We did switch from goldmine to MSCRM. The biggest issue we have now is that it seems that users can only access their own calendars. I was able to make an appointment for another user that want to join the meeting but if there is already a meeting schedule then there is no waring. Also the assistant can not pull up the supervisors calendar to schedule appointments for him. Basically we have a small sales team and 2 people that make the appo...

Functional buttons F3,F4,F5
Hi all, Uh i have e huge problem how can i do this! I need to make functional buttons to do some operations like save ,delete,or print...Press functional button F3 or click on form button Print .... I have buttons alredy and i have code on events on all this buttons. I know the way with main modules too put all this code in modules and then to do if is loaded some form do some event. But it is to complicate and i dont have time to do and test all that. Does somene know how can i do on some easy way . -- Message posted via http://www.accessmonster.com How about attaching them to a macro ...

Counting sales
I have two different datasets. Each with a common identifier. I need a formula that will reference the identifiers in both datasets and count the number of sales a particular agent made. Example. look up this identifier in the other dataset and then give me the value that is 2 columns over from the identifier in the second dataset. See if this helps: http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "Dave" <Dave@discussions.microsoft.com> wrote in message news:E7245B37-033F-400E-9CEE-9822BE7CB0F5@microsoft.com... >I have two...

Counting Cells with Conditional Formatting
Is there a way to look at a row of data that is either highlighted yellow or red and to count only the data that is highlighted yellow and give me that number? None of my data is numerical....just one letter data, i.e.: "S" or "U" I just want to count how many of the cells are highlighted yellow in a specific row, if that makes more sense. Here's a UDF (Put in a Standard module) and use it in cell A1, like =CountByColor(A8:H8,6) << where 6 (at present) = Yellow = change to =CountByColor(A8:H8,3) to get the reds HTH Function CountByColor(InRa...

COUNT ? need formula
Hi, I want to track the results of my teams sales performance. I record if it is a sale, no sale, cancelled etc in column M. I thought I'd be able to use the COUNT function/formula to be able to search for all the SALES in column M and place the result in a cell ( column O )but I can't work it out. Any ideas? Damian Hi! Try this: =COUNTIF(M1:M100,"sale") Biff "Diamond Jones" <kwanzaNOSPAM@optusnet.com.au> wrote in message news:43a0e897$0$17704$afc38c87@news.optusnet.com.au... > Hi, > > I want to track the results of my teams sales perf...

public function
I'm a visual basic programmer and i've made a software that is trying to use a Visual C++ dll, named memctrl. i've implemented the code in the memctrl.cpp file and i'm trying to access the function i've made in the .cpp through Visual Basic 2005. I just can't access them. If i use some functions that are implemented in the memctrl.h, then i have access to them. My doubt is: I've learn that in Visual C++ we declare the functions header in the .h file and we implement the code in the .cpp file. What am i doing wrong? the code: memctrl.h #pragma once #include...

Help to modify a formula
This is my formula I need help with, in cell I10 this is entered =IF((I7-I6)*24>4,(I7-I6)*24-0.5,(I7-I6)*24) Problem is when cell I6 & I7 are blank cell I10 shows #value I need it to be blank or 0 any ideas? thanks all. Bob Bob, You should be getting zero when I6 and I7 are empty. It sounds as if there's a space or something like that in the cell. Some folks do that to clear a cell. -- Regards from Virginia Beach, Earl Kiosterud www.smokeyl.com ----------------------------------------------------------------------- "Bob Bob" <NOeMAILl@mail.com> wrote in me...

Data Migration Issue .........Please Suggest
Hi, I am required to transfer data from Sql Server 2005 which is in different network and domain, its site runs on internet, To Microsoft CRM 3.0. Please Suggest me as how to achieve this. Thanks in advance Misha ...

Count Function
I am creating a report for the number of pupils being collected at a certain collection time e.g. 14:00hr and 15:00hrs using the formula =Count([Child Last Name]) in the collection time footer However when i try to count the overall number of pupils in the footer using the same formula, 'Error' appears on screen? Thanks There are potentially a dozen footer sections in a report. Which one is giving you a problem? What is the name of the control? What is the exact formula? -- Duane Hookom Microsoft Access MVP "ELo" wrote: > I am creating a r...