ExcelBanter - Counting cells with multiple selection

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting cells with multiple selection (https://www.excelbanter.com/excel-worksheet-functions/135115-counting-cells-multiple-selection.html)

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')

Toppers

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')

Teethless mama

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')

All times are GMT +1. The time now is 07:03 PM.