| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
can i use COUNTIF with 2 conditions in excel 2000
respected sir,
i want to use COUNTIF with two condition in excel (greater than 100000 but equal to 200000) i want to count the number of entries in the specified range. please help me |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can i use COUNTIF with 2 conditions in excel 2000
=COUNTIF(A1:A10,200000) On Jan 29, 11:59*am, jahangir wrote: respected sir, * * * * * * * * * * i want to use COUNTIF with two condition in excel (greater than 100000 but equal to 200000) i want to count the number of entries in the specified range. please help me |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can i use COUNTIF with 2 conditions in excel 2000
Hi
=COUNTIF(A:A,100000)-COUNTIF(A:A,200000) -- Regards Roger Govier "jahangir" wrote in message ... respected sir, i want to use COUNTIF with two condition in excel (greater than 100000 but equal to 200000) i want to count the number of entries in the specified range. please help me |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can i use COUNTIF with 2 conditions in excel 2000
greater than 100000 but equal to 200000 is equal to 200000. Second condition
is not correct maybe you mean "less than 200000" which is more logical. "jahangir" wrote: respected sir, i want to use COUNTIF with two condition in excel (greater than 100000 but equal to 200000) i want to count the number of entries in the specified range. please help me |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
can i use COUNTIF with 2 conditions in excel 2000
Hi,
I suspect you mean greater than 100,000 and less then or equal to 200,000? In 2000: =SUMPRODUCT(--(A1:A99100000),--(A1:A99<=200000)) -- If this helps, please click the Yes button Cheers, Shane Devenshire "jahangir" wrote: respected sir, i want to use COUNTIF with two condition in excel (greater than 100000 but equal to 200000) i want to count the number of entries in the specified range. please help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif Conditions - Use of conditions that vary by cell value | Excel Discussion (Misc queries) | |||
| Excel 2000 - COUNTIF | Excel Discussion (Misc queries) | |||
| COUNTIF Formula in Excel with two conditions | Excel Worksheet Functions | |||
| multiple conditions in COUNTIF (Excel 2000) | Excel Discussion (Misc queries) | |||
| Sum with multiple conditions in Excel 2000 | Excel Worksheet Functions | |||
Hybrid Mode
