Google表:如何将单元格值添加到另一个单元格
我想创建一个函数,如果满足条件,可以将当前单元格的值添加到另一个单元格。
从此帮助我
对此/yzbhm.png“ rel =“ nofollow noreferrer”>请
我打算继续添加数据,并认为最好在'Total'列中为每个单元格分配正确的功能。我想我可以使用if()每个a,b和c选择单元格,但不确定如何将每个“总”值添加到“ tracker”到“钱包”中的相应单元格,但仍找不到搜索三天后,合适的功能,我决定最终加入并寻求您的帮助。
请救我
I want to create a function that could add the value of the current cell to another cell if a condition is met.
From this Help Me
to this Please
I intend to keep on adding data and thought it would be better to assign the right function for each cell in the 'total' column. I think I can use IF() to select cells per A, B, and C, but not sure what to do with adding each 'total' value from 'TRACKER' to the corresponding cell in 'WALLET' And still couldn't find the right function after three days of search, and I decided to finally join and ask for your help.
Please save me
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您需要
sumifs()
函数就像 -查看您的工作表。
You need
SUMIFS()
function like-See your sheet.
如果重复姓名和字母,则可以使用
= sumifs()
。也许您可以使用枢轴表代替三个表。If name and letter are repeated you can use
=SUMIFS()
. Maybe you can use a pivot table instead of the three tables.