| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
2 questions regarding count formula
additional details he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html "Melinda" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to count numbers | Excel Worksheet Functions | |||
| Using the $ in a count formula | Excel Discussion (Misc queries) | |||
| Count If Formula | Excel Discussion (Misc queries) | |||
| Formula format for Count or Countif funtion with two criterias | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
Threaded Mode
