Sum of values in Column B based on specific value in Column A.
B列中的值总和基于A列中的特定值。
I am a new bee. So bear with me plx
我是一只新蜜蜂。所以忍受我plx
For example: If we select Oct-2016
in Column A it gives us sum of all numeric in Column B or Column C or Column D
.
例如:如果我们在A列中选择Oct-2016,它会给出B列或C列或D列中所有数字的总和。
I want to sum all the details of Oct-2016 of a particular person.
我想总结某个人2016年10月的所有细节。
See it on Google drive
在Google云端硬盘上查看
What have i tried... =SUMIF(B2:B32,DATE(2016,10,0),SUM(B2,B32)
我尝试了什么... = SUMIF(B2:B32,DATE(2016,10,0),SUM(B2,B32)
Also tried
=SUMIF(B2:B32,"="&DATE(2016,10,1),G2:G32)
// but my date doesn't contain day
= SUMIF(B2:B32,“=”&DATE(2016,10,1),G2:G32)//但我的日期不包含日期