nested count if statement

[organicjan]

I need to nest a count if statement to add three criteria. The orignial is +COUNTIF(C3:C70,"=W") and I need to add to that count if the range =C and count if the range =E.

Thanks for your help!

 

[Cam]

Give this a try.


=COUNTIF(A1:A10,"C")+ COUNTIF(A1:A10,"E")+COUNTIF(A1:A10,"W")

 

[Aladin Akyurek]

On 2002-08-28 12:22, organicjan wrote:
I need to nest a count if statement to add three criteria. The orignial is +COUNTIF(C3:C70,"=W") and I need to add to that count if the range =C and count if the range =E.

Thanks for your help!

Also

=SUMPRODUCT((A1:A10={"C","E","W"})+0)

If you insert a row before your data and enter a label in A1, say, "field", you can also set up a criteria range in order to use DCOUNTA:

In C1:C4 enter:

{"field";"c";"e";"w"}

In C5 enter:

=DCOUNTA(A1:A11,1,C1:C4)

See the figure...

Book9
	A	B	C	D
1	field		field
2	q		c
3	w		e
4	e		w
5	x		3
6	c		3
7	f
8	g
9	h
10	I
11	q
Sheet1