countif? #3

hi, i'm stuck with a formula.

I need to count the number of cells in the whole of column K tha
contain the numbers 6,7 and 8.

I can't seem to find a way to do this, 

Any help would be greatfully recieved

Regards

Pet

--
Message posted from http://www.ExcelForum.com

0
5/13/2004 12:00:52 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
509 Views

Similar Articles

[PageSpeed] 33

try this. You cannot use A:A here.
=SUMPRODUCT((A2:A10={6,7,8})*1)

-- 
Don Guillett
SalesAid Software
donaldb@281.com
"Pete JM >" <<Pete.JM.16713e@excelforum-nospam.com> wrote in message
news:Pete.JM.16713e@excelforum-nospam.com...
> hi, i'm stuck with a formula.
>
> I need to count the number of cells in the whole of column K that
> contain the numbers 6,7 and 8.
>
> I can't seem to find a way to do this,
>
> Any help would be greatfully recieved
>
> Regards
>
> Pete
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


0
Don
5/13/2004 12:16:55 PM
Hi Pete!

You can use this formula to count all cells with the value 6:
=COUNTIF(K:K;6)

If you need to count all the cells with the value 6, 7 and 8, then you can 
use this array formula:
=SUM(COUNTIF(K:K;6)+COUNTIF(K:K;7)+COUNTIF(K:K;8))
When writing array formulas, you have to hold down Ctrl+Shift when pressing 
enter.
Then when you look at the formula bar, it looks like: 
{=SUM(COUNTIF(K:K;6)+COUNTIF(K:K;7)+COUNTIF(K:K;8))}

Best regards

Stefan H�gglund
Microsoft

"Pete JM >" <<Pete.JM.16713e@excelforum-nospam.com> wrote in message 
news:Pete.JM.16713e@excelforum-nospam.com...
> hi, i'm stuck with a formula.
>
> I need to count the number of cells in the whole of column K that
> contain the numbers 6,7 and 8.
>
> I can't seem to find a way to do this,
>
> Any help would be greatfully recieved
>
> Regards
>
> Pete
>
>
> ---
> Message posted from http://www.ExcelForum.com/
> 


0
stefanha (71)
5/13/2004 12:18:26 PM
Hi
try
=SUMPRODUCT(--(K1:K1000={6,7,8}))

or use 3 COUNTIFS and add them

>-----Original Message-----
>hi, i'm stuck with a formula.
>
>I need to count the number of cells in the whole of 
column K that
>contain the numbers 6,7 and 8.
>
>I can't seem to find a way to do this, 
>
>Any help would be greatfully recieved
>
>Regards
>
>Pete
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>
0
frank.kabel (11126)
5/13/2004 12:19:39 PM
Reply:

Similar Artilces:

Direct upgrade from CRM 1.0 to 3.0
Has anybody sucessfully done an upgrade from 1.0 to 3.0 with out first doing an upgrade to 1.2? If so please can you give me some tips how to do this. Thanks You must first upgrade from CRM 1.0 to CRM 1.2 then you can upgrade to CRM 3.0 ======================= John O'Donnell Microsoft CRM MVP http://codegallery.gotdotnet.com/crm "John Steskal" <John Steskal@discussions.microsoft.com> wrote in message news:1F5178F3-84CF-4A44-8D9A-7668BAA3CEFA@microsoft.com... > Has anybody sucessfully done an upgrade from 1.0 to 3.0 with out first > doing an upgrade to 1.2? If...

Recovering An Overwritten File #3
I overwrote a spreadsheet with a blank spreadsheet. How do I recover my previous spreadsheet? If you don't have a backup, I think you lost it. Any chance you emailed a copy to someone else--then you may have a copy in your sentbox or can ask that recipient to mail a copy back? Need To Recover A Spreadsheet wrote: > > I overwrote a spreadsheet with a blank spreadsheet. How do I recover my > previous spreadsheet? -- Dave Peterson ...

email question #3
I realise that this isn't specifically outlook, but my useless ISP cannot answer my questions. My question is do ISP's sometimes check the email address when you try to receive pop mail? My pop settings have the correct account and password, but a different email address to the one the ISP has provided (it is my domain email address and I forward the email to my ISP email address). I was intermittently getting questioned about my account name and password, but when I changed the email address to the ISP one the problem went away. I have got around it by putting my real email a...

POP 3 Connector problem on Exchange Server 5.5
Hi there, I am having a problem with junk email with null characters. (see http://support.microsoft.com/default.aspx?scid=kb;en-us;280331). This has only become a problem is the last month or so. As the article says, "This behavior occurs because one or more e-mail messages in the mailbox of the POP3 server may contain Null characters and the POP3 Connector for Small Business Server 4.5 is not able to download e-mail messages if they contain Null characters." 1. Can someone explain to me what a "null character" is? 2. What are some options to cure the problem. Simp...

How to add a cover page to a fax in CRM 3.0 Beta
Hi, Just installed 3.0 Beta and are testing it out. Noticed you can now add a cover page to a fax activity. It is a list box, but under help I could not find info on how to add fax covers to a fax activity. Anyone know how? Thanks! Shauna Thanks Matt for your e-mail response. Looks like, so far, you can only do it in Microsoft Dynamics CRM 3.0 Small Business Edition (SBE) when running on Microsoft Windows Small Business Server (SBS) 2003. Does Microsoft have any plans to make this available in the regular CRM server world? This would be a handy feature to have. Thanks! Shauna &q...

CRM 3.0 Sales for outlook and message attachment issues
Hi everyone I have noticed a strange issue and need some help. I have 2 users using sales for outlook. They both have the exchange routing rule listed within their outlooks rules. When they receive an email with messages forwarded as attachments they see the message attachments but when they click on them they are blank. When they disable the CRM forwarding rule and I resend the message they can open the attached message and the contents are there. Any help or suggestions on this issue would be most appreciated. ...

Status bar shows 3 messages sent when only 1 email sent
Using Outlook 2007 When I send an email, I notice that the information bar on the bottom of the screen states that 3 emails are being sent. It says 'Sending message 3 of 3' when I have only sent one email (single recipient, no blind copies etc). I usually force the send using the sned/receive button so this isn't emails collecting in the outbox. Does anyone know why this is? Is it because I use Outlook to manage 3 email accounts during the send/receive? How can I get Outlook to show me exactly what is being sent (rather than just looking at what was sent...

RPC over HTTPS fails following install of SharePoint Services 3.0
Hello, I yesterday did an inplace upgrade of Windows SharePoint Services 2.0 to 3.0 which runs on the same server as Exchange. RPC over HTTPS was until this point working fine but has not been since. All other Exchange functionality seems to be OK including OWA access over an SSL connection. The only error I can find is below (I've changed machine names and IPs) and help would be greatly appreciated. ------------------------------------------------ Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1309 Date: 18/01/200...

CString Question #3
How do you go about passing information from one class to a dialog box class. I can do it useing char pointers , i was wanting to try CString pointers. Am i missing something eg CDeleteConformation::CDeleteConformation(char *DeleteTableName) : CDialog(CDeleteConformation::IDD) I know that i can pass cstring into but how do i pass it back as a pointer to an address. so i can change it. CDeleteConformation::CDeleteConformation(CString DeleteTableName) : CDialog(CDeleteConformation::IDD) thanks kevin_mfc@ihug.com.au >eg >CDeleteConformation::CDeleteConformation(char *DeleteT...

Outlook 2003 email problem #3
I switched from Thunderbird to Outlook 2003 for email. I can send but not receive. I changed the default email client to outlook but to no avail. I can still receive email in TBird. XYZ man What happens when you use the test account option? Exact err msg? "XYZ man" <xyzman@optonline.net> wrote in message news:%23ypy5rHxGHA.4752@TK2MSFTNGP02.phx.gbl... > I switched from Thunderbird to Outlook 2003 for email. I can send > but not receive. > I changed the default email client to outlook but to no avail. I > can still receive email in TBird. > XYZ man Hi D...

Is this possible ? #3
Is this possible? I want to compare a number against 3 ranges and display a comment for the range it fits into. Example. Let's say the number is 6 <4 - would display no comment between 5 and 15 - would display the comments "standard" >15 would display no comment. This is only one line of comparison. Moving down the worksheet the next example might look like this. Let's say the number is 147 <80 - would display no comment between 81 and 125 - would display no comment >125 would display the comment "below standard" I am very new at vlookup a...

Implementing 3-Tabs to Existing Dialog Project
I have an application (MFC dialog type) that needs to be modified. The current app provides the customer a type of "Test" to be performed. As part of an Add-On, I want to add a 3-tab control (CPropertySheet & CPropertyPage) where the existing "Test 1" is done on tab 1. Then I will add a "Test 2" & "Test 3" on Tab 2 and Tab 3. The user can choose which "Test" to do based on selecting the proper Tab. I created the CMyPropertySheet along with the 3-Tabs (CTab1, CTab2, CTab3). The problem is this. Right now the 3-tab di...

Any one have crm 3.0 installation and config certification dumps ,
Hi Folks , If Any one have crm 3.0 installation and config certification dumps , Please post it or send to krishna.919ATgmail.com=20 Thanks=20 Kris=20 Reply =BB Are you refering to this? CRM 3.0 90 Days trial http://www.microsoft.com/downloads/details.aspx?FamilyID=7d418781-69ad-422d-92fa-87fdb2538e2c&DisplayLang=en <krishna.919@gmail.com> wrote in message news:1150431561.738912.313120@g10g2000cwb.googlegroups.com... Hi Folks , If Any one have crm 3.0 installation and config certification dumps , Please post it or send to krishna.919ATgmail.com Thanks Kris Reply � ...

Using Outlook client for CRM 3.0 in a remote office
I need to set up access to the corporate CRM from several remote offices. All of them have VPN connections (Windows or Checkpoint). What are the steps required to configure remote clients to be able to use CRM features in Outlook. Remote users can connect to CRM through Internet Expolorer. Thanks. Assuming they are connected, the isntallation over a VPN connection should not be any different than a typicaly installation. If the connection is slow though, the first synch & Go Offline process will be noticiably slower though. -- Matt Parks MVP - Microsoft CRM "mkatsev"...

Upgrade to CRM 3.0 Small Business Edition?
We recently purchased CRM 1.2 for Small Business Server 2003 Professional (Sales Force). With the Software Assurance-Open Service Plan, will we be able to get a free upgrade to Microsoft CRM 3.0 Small Business Edition when it becomes available? as you have the software assurance plan my information says that you will get an upgrade to v3 when its released -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "DonnaDea" <DonnaDea@discussions.microsoft.com> wrote in message news:909F3C72-5FAC-4C83-A94A-40C0C253AFF8@microsoft.com... > We recently purchased CRM ...

xpath problems #3
Hello, I am trying to get all the elements that are inside the <group> tag in this function and it doesn't work. What is wrong with that? private void populateTreeControl( System.Xml.XmlNode document, System.Windows.Forms.TreeNodeCollection nodes) { XmlNodeList xmn = document.SelectNodes("/sectionGroup/*"); foreach (System.Xml.XmlNode node in document) { string text = (node.Value != null ? node.Value : (node.Attributes != null && node.Attributes.Count > 0 ) ? node.Attributes[0].Value : node.Nam...

Training Mode #3
Hi Guys this was a big problem for me when trying to sell RMS the fact that the only way to have training mode was to change all the setting in RMS. Well i have come up will a solution that allows you to click a button and switch databases and it also makes the till clearly state that its in training mode. If anyone is interested and want to see more please email me at tom@psltd.net or phone on +442082755564 price is negotiable depending on amout of licences wanted You can do this for free by exporting the "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Oper...

Upgrading #3
I have Money Delux and Small Bus 2003. I use it promarily for investments and some simple small bus stuff. Does 2004 small bus give me all the stuff that premium has? ...

1.2 to 3.0 Upgrade / Install
So I'm trying to upgrade our demo server, and get these two errors (amongst others); (and I'm para-phrasing) 1) Triggers inconsistent with 1.2 (extra ones in database) 2) SP's inconsistent with 1.2 (missing?) so.. 1) how does it check for extra SP's ? (is there a SQL script that can be run?) I know there might be extra ones in there, and I'm willing to clean them out but without checking every table..?) 2) what SP's is it looking for ? thanx for any help, kind words of encouragment, etc -- Glen Howie Microsoft CRM Product Specialist WolfBridge Solutions www.wol...

Help balancing SAVINGS account on 3 month cycle?
My bank sometimes sends me a bank statement for my checking account, and the statement cycle is 92 days. How do i go about balancing this if they also send 30 day cycle statements? I'd flip a coin and balance on one cycle or the other. "BoDEAN" <jbodean@mail.remove.com> wrote in message news:d8tb00p0tgjnfuqs6875m35mgkjq18ifcs@4ax.com... > My bank sometimes sends me a bank statement for my checking account, > and the statement cycle is 92 days. > > How do i go about balancing this if they also send 30 day cycle > statements? > > ...

Import External Data #3
In Excel 2003 (XP) I have set up a few stocks that I update thru Data, Import External Data, Edit Query, Import. Is there any way to add a couple of indecies like the Dow Average to this edit? The easiest way for me has been to setup multiple Web Queries, but have them coming into a garbage sheet somewhere, so I can just pull it all down. Then I use cell references to organize the data over onto a Display Sheet that has thing the way I want to see them. You could get your additional stuff tucked in easily the way you want, and formatted to your tastes. -- "Actually, I *am* a ro...

CRM 3.0 - 4.0 and SQL 2000
Hi We have an environment where we are running CRM 3.0 on SQL 2000 on the SBS version(on the same machine). We want to upgrade to CRM 4.0 but on a new machine. Can someone please advise me the series of steps that i need to follow. I am not sure where to start. My guess is that I need to migrate the database from SQL 2000 - SQL 2005 first and then install CRM but how do i migrate from SQL 2000 to SQl 2005. I would really appreciate some expert suggestions here. Kind Regards Snow White Here are the high level steps: 1. Setup your new SBS R2 enviornment (review with your IT Admin or ...

How do I create 3 text boxes on a page?
I am trying to create an exam that will have 3 text boxes. I need for the text boxes to expand as the student types in the answers and to continue to an additonal page if necessary. This is my first Publisher project and I'm a bit lost! Go here Text boxes http://office.microsoft.com/en-us/publisher/CH063585551033.aspx Scroll down to the "Connect text boxes" entry. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "agrissom" <agrissom@discussions.microsoft.com> wrote in message news:1AE053CB-3E28-447A...

CRM 3 in Single Server Deployment
Hi everyone, I was wondering, if i want to use the single server deployment for CRM 3. (i.e have, Active directory, CRM, SQL and Exchange on one server) Do i have to use Small Business Server, or can I use windows 2003 standard. Thanks in advance Ranga SBS is the only supported Single Server Env. Please read Implementation Guide. SBS is the only supported Single Server Env. Please read Implementation Guide. ...

Signature font #3
Is there a way to force the automagically added signatures to adopt the font one has selected as default for email replies? Thank you, -Martin Martin <0_0_0_0_@pacbell.net> wrote: > Is there a way to force the automagically added signatures to adopt > the font one has selected as default for email replies? Replies always use the format of the original message. -- Brian Tillman You must mean the signature, because I have a font specified as my preference for replies and that is always automatically selected when I reply. The signature always gets added-on with the incom...