这是我的数据
Company Year Name Position Gender Sales
(0=Male)
Johnson & Johnson 2016 Alex Gorsky Director 0 71891000
Johnson & Johnson 2016 M. C. Beckerle Director 1 71891000
Johnson & Johnson 2016 D. S. Davis Director 0 71891000
Johnson & Johnson 2016 I. E. L. Davis Director 0 71891000
Johnson & Johnson 2016 M. B. McClellan Director 0 71891000
Johnson & Johnson 2016 A. M. Mulcahy Director 1 71891000
Johnson & Johnson 2016 W. D. Perez Director 0 71891000
Johnson & Johnson 2016 C. Prince Director 0 71891000
Johnson & Johnson 2016 A. E. WashingtonDirector 0 71891000
Johnson & Johnson 2016 R. A. Williams Director 0 71891000
Johnson & Johnson 2015 Alex Gorsky Director 0 70079000
Johnson & Johnson 2015 M. C. Beckerle Director 1 70079000
Johnson & Johnson 2015 D. S. Davis Director 0 70079000
Johnson & Johnson 2015 I. E. L. Davis Director 0 70079000
Johnson & Johnson 2015 M. B. McClellan Director 0 70079000
Johnson & Johnson 2015 A. M. Mulcahy Director 1 70079000
Johnson & Johnson 2015 W. D. Perez Director 0 70079000
Johnson & Johnson 2015 C. Prince Director 0 70079000
Johnson & Johnson 2015 A. E. WashingtonDirector 0 70079000
Johnson & Johnson 2015 R. A. Williams Director 0 70079000
Johnson & Johnson 2015 M. S. Coleman Director 1 70079000
Johnson & Johnson 2015 S. L. Lindquist Director 1 70079000
Johnson & Johnson 2014 Alex Gorsky Director 0 74336000
Johnson & Johnson 2014 D. S. Davis Director 0 74336000
Johnson & Johnson 2014 I. E. L. Davis Director 0 74336000
Johnson & Johnson 2014 M. B. McClellan Director 0 74336000
Johnson & Johnson 2014 A. M. Mulcahy Director 1 74336000
Johnson & Johnson 2014 W. D. Perez Director 0 74336000
Johnson & Johnson 2014 C. Prince Director 0 74336000
Johnson & Johnson 2014 A. E. WashingtonDirector 0 74336000
Johnson & Johnson 2014 R. A. Williams Director 0 74336000
Johnson & Johnson 2014 M. S. Coleman Director 1 74336000
Johnson & Johnson 2014 S. L. Lindquist Director 1 74336000
Johnson & Johnson 2014 J.G. Cullen Director 0 74336000
Johnson & Johnson 2014 L.F. Mullin Director 0 74336000
这个名单还有很长的一段。
我需要在新行中以百分比（例如 0.2）显示男性/女性的比例，并按年份单独计算。
我有一些编程知识，但只是不知道从哪里开始以及如何开始。
答案1
您也可以使用数据透视表来计算它。
由于您的性别已作为数值给出0，因此1计算平均值将得出1以下百分比：
答案2
您需要创建一个辅助表。
尝试这个
=IFERROR(COUNTIFS(B:B, E1, A:A, D1)/COUNTIF(A:A, D1), 0)
然后，您可以通过将数字格式更改为百分比
如果没有与您的表匹配的年份（您正在寻找 2013 年的数据），则必须将代码包装在其中IFERROR，否则您将收到DIV/0错误。
确保年份A和D格式正确都一样作为文本或数字（或日期）。
