1. 1. Cell B8 到B11分别输入A,B,C,D




2. Cell C8 输入以下方程式

  
    =COUNTIFS($3:$3,B8,$5:$5,">0")
  

3. 然后Copy C8 到C9,C10和C11


4. 完成

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---