Hi Melinda,

You can use the sumproduct function with a range that is sufficient to
include new data e.g.

=SUMPRODUCT(--(A2:A200="Melinda"),--(B2:B200=1),--(C2:C200=4),--(C2:C200<=8))

Hth
Anthony


"Melinda" wrote:

If I have the following data

A B C
1 Personnel group type p't number
2 Melinda 1 4
3 Sean 1 5
4 Melinda 1 6
5 Sean 2 30
6 Fay 3 8
7 Melinda 1 32

1. How shall I contruct my formula to count the number of data that satisfy
the following criteria:
1. personnel is Melinda
2. group type is 1
3. p't number is between 4 and 8

2. When designing the formula, can the formula be extended in such a way
that even if I add more data to the table above, I can still get an accurate
count without redefining my data range in the formula?

Thanks.
Melinda