基于特定行(人)的列值总和

时间:2021-11-06 07:38:56

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)//但我的日期不包含日期

1 个解决方案

#1


0  

Test1 Test2

=IF(B3=$K$2,C3,0) 

You may try this formula as updated in the image to resolve the problem quick. Thanks.

您可以尝试在图像中更新此公式以快速解决问题。谢谢。

#1


0  

Test1 Test2

=IF(B3=$K$2,C3,0) 

You may try this formula as updated in the image to resolve the problem quick. Thanks.

您可以尝试在图像中更新此公式以快速解决问题。谢谢。