2 questions regarding count formula
what does the "--" mean? I found that if I remove that from my formula, it
will not work. Does it have special meaning?
Melinda
"Anthony D" wrote:
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
|