| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting cells with multiple selection
Hi,
How Can I have multiple condition using countif function Can we use the Countif function or any other function if we are working with dates or strings. Ex: to count cells between 2 set of dates or to count cells that match string('sale' or 'quote') |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting cells with multiple selection
Look at SUMPRODUCT
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html "ub" wrote: Hi, How Can I have multiple condition using countif function Can we use the Countif function or any other function if we are working with dates or strings. Ex: to count cells between 2 set of dates or to count cells that match string('sale' or 'quote') |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting cells with multiple selection
Count how many days between Jan 1 to Jan 10
=COUNTIF(B1:B100,"="&--"1/1/2007")-COUNTIF(B1:B100,""&--"1/10/2007") Count sale or quote =SUM(COUNTIF(A1:A100,{"sale","quote"})) Adjust to suit "ub" wrote: Hi, How Can I have multiple condition using countif function Can we use the Countif function or any other function if we are working with dates or strings. Ex: to count cells between 2 set of dates or to count cells that match string('sale' or 'quote') |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells with multiple data | Excel Worksheet Functions | |||
| Counting cells using multiple parameters | Excel Discussion (Misc queries) | |||
| Counting cells using multiple criteria | Excel Worksheet Functions | |||
| Counting text in multiple cells. | Excel Worksheet Functions | |||
| Counting multiple cells using a criteria | Excel Discussion (Misc queries) | |||
Linear Mode
