excel - Excel formula like MLM
问题描述
As the picture, the explanation as below:
J.Li and E.Bn will join into R.B team, then you can see the Level 1 those have 1. Then J.Li and E.Bn they also have their team, so that B.Ko and K.Un will join into J.Li team, you can also see that Level 1 those have 1 too, and C.Ki and X.Pq will join into E.Bn team, in his Level 1 also has 1 too, in this moment, you can see team R.B, the Level 2 will be appear 2 and 2, because his 2 members J.Li and E.Bn they also have members, that’s why will put the number into his Level 2, the case in Level 3 is same.
I want to know that how to do this formula is there are many member and new team create under this sheet? I have try to find spreadsheet formula, but no idea for this formula.
解决方案
假设第一列是 A 列。
级别 1:值始终为 1
Level 2:是'MEMBER's name出现在A列中的次数。
解决方案>一个countif()
公式应该做的。以上述为条件。
3 级:是“会员”2 级的总和。
解决方案 >sumif()
在 F 列(第 2 级)上执行。与 2 级条件相同。
希望它解决..(:
推荐阅读
- postgresql - Postgresql Alter Table freezes DB (CPU is high-loaded by some Select)
- javascript - javascript子函数事件分配
- docker - Cannot create a SQL Server 2019 pod, but can create an SQL Server 2017 pod. Why can't I create an SQL Server 2019 pod?
- git - 未在 github 中显示的贡献和与每个提交无关的电子邮件 ID
- keycloak-gatekeeper - nginx入口反向代理背后的Keycloak Gatekeeper
- php - 试图获得非对象的属性“课程”
- c - 你能给我关于优雅的评论吗?
- pagespeed-insights - PageSpeed Insights 错误地标记了网站
- react-native - 是否有可用于 React Native 和 Web 浏览器 (Javascript) 的 WYSIWYG 文本编辑器?
- delphi - 组件到屏幕的 Y 位置,其中组件在其他组件之上