countif function

CSmall · May 10th, 2002, 10:00 AM

Is it possible to return a "countif" value based on two conditions? All data is text format.I wandered into the world of arrays (CSE) in the course of my search...very interesting but...more confused than before.

Aladin Akyurek · May 10th, 2002, 10:05 AM

Quote:

On 2002-05-10 09:00, CSmall wrote:
Is it possible to return a "countif" value based on two conditions? All data is text format.I wandered into the world of arrays (CSE) in the course of my search...very interesting but...more confused than before.

Since you're mentioning multiple conditions, you have to use either an array-formula or an equivalent SUMPRODUCT formula, or Database function.

A SUMPRODUCT formula would be:

=SUMPRODUCT((A2:A20=E1)*(B2:B20=E2))

This would produce a count where A2:A20 satifies a condition in E1 at the same as B2:B20 satisfies a condition in E2.

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-05-10 09:06 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 10:00 AM	#1
CSmall New Member Join Date: May 2002 Posts: 1	Is it possible to return a "countif" value based on two conditions? All data is text format.I wandered into the world of arrays (CSE) in the course of my search...very interesting but...more confused than before.