6 Resources for

countif

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

Assigning numeric values to yes no validation: Is there anyway that you could assign a numeric value to a "Yes" "No" validation? E.G. if i was to set up a spreadsheet with 10 Questions,and responded by saying yes to 7 of them ( by using the data,validation,list function).I need the spreadsheet to allocate 7 points/marks.Meaning the yes...; Tags: PRODUCTIVITY, llewellyn.wooldridge@..., Countif; Discussion threads 2007-10-23
Excel Autonumber: I need to allocate an incremental number to a cell in the Count column based on one of three options typed into the Item cell adjacent as follows:Item CountA 1B 1C...; Tags: C/C++, Programming languages, colin.radcliffe@..., Microsoft Excel, Countif, C; Discussion threads 2007-10-16
Excel question: In an excel file, i have 2 worksheets called "A" and "B". "A" has a load of data on the sheet with a filter turned on. B is a blank worksheet. In "A" i filter it down for things that happened between 2 dates, say >10-1-06 and <...; Tags: Excel Question, COUNTIF, Range, Ronan.Anglin@..., software, Microsoft Excel; Q&A 2006-04-27
Excel nexted functions: I'm trying to count student attendance if they are Special Education students, ie =if(f15="P"+ae15="1"),1,0 (if one cell is "P" AND another cell is "1" then return "1")This returns "invalid" or "value" and function doesn't work. When I get the function to work, it returns an incorrect value. How...; Tags: A1=P, B1=1, blginger@..., C, cell, COUNTIF, Microsoft Excel, software, Special student; Q&A 2005-12-24
Excel formula, text in column to a value: I have a column in my excel spreadsheet that has a name entry, e.g D1 = Tony, D2 = Fred, D3 = Gordon, etc. The names can appear in the same column more than one, e.g Tony appears say 5 times, Fred 2 times and Gordon 4 times. I...; Tags: COUNTIF, Fred, Ivan the Terrible, Microsoft Excel, software, Tony; Q&A 2005-09-20

Tech Tip: Print Word docs in reverse/Determine Excel data frequency/Keep form controls in Access: Print documents in reverse Many ink-jet printers typically stack multipagedocuments with the first page on the bottom, which forces you tocollate the copies in the correct page order. This can be atime-consuming process, particularly if you're on your way to ameeting. However, you can...; Tags: COUNTIF, CountIf Function, Event Date, Microsoft Access, Print Word; Technical articles 2004-08-02

Additional Resources

If Statements: I am working on a spreadsheet in Excel. I would like to see if I can get this to do the following, if k23:k27>0 then I need these values to be avareaged without including the 0 value.Also, I need some help with the following, similar to the previious one:...; Tags: beachlabrat@..., A1:A20, Sumif; Discussion threads 2007-10-22
sum with two logical tests in excel: Hi I am trying to sum cells that meet two conditions. This is the formula I was trying to use but it gives me 0. Please help. So if cells b29-253 greater than 0 and if cells j29-253 = Bay Insulation (1%10/30 50k) than sum the amounts in...; Tags: nkoeller@..., cell, Bay Insulation; Discussion threads 2007-10-12
Excel Dates: using the countif function, i want to count all the dates in a range that are within the week. Please help!!!! Today-7 will count 7 days before but i want to do from that week, i.e from Monday if its only Wednesday, not from last Wednesday. This will; Tags: software, windows, ak47kalam@..., Microsoft Excel; Discussion threads 2006-12-09
Use cell locations generated from ADDRESS function in EXCEL: I have been able to generate a range using the ADDRESS function in EXCEL, but cannot find a way to use this range to be used in a COUNTIF formula.How can I plug in the range received by the ADDRESS function into an array statement?Thanks; Tags: vfiduccia@..., Microsoft Excel; Discussion threads 2007-11-15
Selective Count in MS Access: I've created a report that needs to count dates belonging to a particular month from a range of dates. How do I do this in Access since the countif and dcount functions don't seem to work in reports?Use Monthe.g. to count the orders for july, try this:SELECT COUNT(*) FROM Orders...; Tags: Count, Microsoft Access, Microsoft Corp., nobby4949@..., software; Discussion threads 2005-03-02
Use a function to count cells between two values in Excel: Are you ready to teach Excel a new trick? Mary Ann Richardson explains how to count the number of cells whose values fall between two particular numbers in a certain range automatically. Excel has no built-in function that can count the number of cells whose values fall between...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, cell, Microsoft Office Suite Excel Tips Newsletter, Function, Office Suites, Software; Technical articles 2006-06-06
Convert text in a call to a number: I have an excel spreadsheet that has a column which can have one of three text words entered “Windows, UNIX or Hardware”.I want to find a way to convert those three words into numbers so I can automatically generate a total amount in a separate column.Example: If I have the...; Tags: Operating systems, Microsoft Excel, Microsoft Office, Microsoft Windows; Q&A 2005-06-13
How to get the right average in Excel: Excel's Average function considers all the entries in the input range and 0s matter. For instance, if the input range is three cells, and one of those cells contains a 0, Excel totals the values and divides by 3. That's probably what you'd expect and what you want. ...; Tags: Microsoft Excel, Cell, Susan Harkins; Blog posts 2007-09-10
I need a 'countif' equivalance in Access: Hi, I am trying to create a query where it will count the occurance of distinct elements in a column. Example: Column name is Question1, and its values can be any of the following: 'Excellent', 'Good', 'Fair', 'Poor'. I would like to run a query to see how many...; Tags: kosheno@..., Microsoft Access, SELECT, software; Q&A 2005-10-12
Mariner Calc (dmg): Mariner Calc starts faster, uses less disk space and memory than any other competitor on the Macintosh platform. With more than 140 built-in functions, charts, named ranges, split and freeze window panes, print preview, find, sorting, auto-sum, protected worksheets, and cell borders, Mariner Calc enables you to turn data into...; Tags: Window, Tool, Mariner Software, Mariner Calc, Microsoft Excel, Productivity, Construction, Microsoft Office, Office Suites, Software; Software downloads 2008-02-22
Preventing duplicate records Excel 2003: I have a spreadsheet that one of the columns is P.O. numbers. I want to make sure as I am entering data that I do not key in the same P.O. number more than once. I looked at data filters with unique records but that did not look...; Tags: edudley@..., John Walkenbach, Microsoft Excel, P.O., P.O. Number, software; Q&A 2005-03-23
Counting items in an Excel list: It's easy to sort your customer database by ZIP code, but do you know in which ZIP code the majority of your customers reside? Here's a tip for counting how many times an entry appears in a list.I hate it when I see users wasting time doing something manually that...; Tags: PRODUCTIVITY, Jeff Davis, ZIP code, unique entry, Advanced Filter, Microsoft Excel; Technical articles 2000-04-12
Prevent duplicate Excel entries within a range: If you want to avoid duplicate entries within a range when you're working in Excel, then check out this tip from Mary Ann Richardson. You'll learn how to set it up and avoid redundancy. Sometimes you may want to prevent users from entering duplicate values in a range...; Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, item number, Microsoft Office Suite Excel Tips Newsletter, Office Suites, Software; Technical articles 2006-02-21
A faster way to count items in an Excel list: TechRepublic members propose a way to count items in an Excel list that's faster than the way Jeff Davis suggested.I love it when somebody teaches me a faster, better way to do something. In “Counting items in an Excel list,” I showed you my way of solving a common business...; Tags: Figure B Here, Jeff Davis, ZIP code, Subtotals feature, Excel List, Microsoft Excel; Technical articles 2000-04-21

<< Previous
page 1 of 1
Next >>

Content Types

Discussion threads (2 results)

Q&A (3 results)

Technical articles (1 results)

Disaster Prevention and Recovery in Windows Server 2003: The Windows Server 2003 Volume Shadow Copy Service offers even small IT shops a unique opportunity to back up just like the big guys. Our Windows Serv ...; Buy Now

Microsoft Access Basics: Buy Now