Excel formula

[doris.barrett]

Need to check a range of cells = 4 or 5 and return the number of cells that meet the condition.
This message was edited by doris.barrett on 2002-09-20 11:16

 

[Joe Was]

Use the "CountIf" function. JSW

 

[IML]

You could use
=COUNTIF(yourrange,4)+COUNTIF(yourrange,5)

good luck

 

[Brenkenathan]

COUNTIF(range,criteria)
example: CountIf(A1:A40,4)

This is really nice expecially if you only need it to count if you have a reason but it counts by itself too

 

[VoG]

Example

=COUNTIF(C1:C9,4)+COUNTIF(C1:C9,5)

 

[Dave Patton]

1. try countif =COUNTIF(A1:F4,4)+COUNTIF(A1:F4,5)

with criteria in G7 and G8
=COUNTIF(A1:F4,G7)+COUNTIF(A1:F4,G8)

or

2 SumProduct
=SUMPRODUCT((A3:F3={4;5})+0)
with criteria in G7:G8
=SUMPRODUCT((A3:F3=G7:G8)+0)
or
=SUMPRODUCT((C1:C4={4,5})+0)
or with criteria in G7:H7
=SUMPRODUCT((C1:C4=G7:H7)+0)

Adjust the references as necessary.

 

[Mark W.]

Dare I introduce one more way...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Field1		Field1		Thereare7ofthem
2	5		4
3	3		5
4	2
5	1
6	5
7	3
8	4
9	4
10	1
11	2
12	2
13	4
14	5
15	5
16	3
17
Sheet2