Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get started using the Countif, Countifs option with Excel
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get started using the Countif, Countifs option with Excel
In A1:A10, enter a letter in each: a, b, c, x, y, z. a, b, c, a
In B1 enter =COUNTIF(A1:A10,"a") this will return a count of how man 'c' values in A1A:10 So will =COUNTIFS(A1:A10,"a") In D1:D10 enter some values: 4, 5, 6, 7, 8, 5, 7, 8. 9, 3 In E1 =COUNTIF(D1:D10,"=5") returns how many have values of 5 or more in E2 enter 5 In E3 =COUNTIF(D1:D10,"="&E2) returns how many have values equal or more than value in E2 In F1 =COUNTIF(a1:a10,"c",B1:B10,5) count how many row have c in columne A and 5 in column B Now experiment ! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "mlkkrs" wrote in message ... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get started using the Countif, Countifs option with Excel
Hi,
Kindly refer to the Help menu. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "mlkkrs" wrote in message ... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get started using the Countif, Countifs option with E
http://www.google.com/search?hl=en&q...=f&oq=&aqi=g10
http://www.google.com/search?hl=en&q...=f&oq=&aqi=g10 That was easy. Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Ashish Mathur" wrote: Hi, Kindly refer to the Help menu. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "mlkkrs" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
Countif compares to Countifs | Excel Worksheet Functions | |||
Replacing COUNTIFS with COUNTIF | Excel Worksheet Functions | |||
Get Started Tab in Excel 2007 | Setting up and Configuration of Excel | |||
Can Excel be started minimized? | Setting up and Configuration of Excel |