在其行中的单元格中具有特定值的列中的Sum单元格 [英] Sum cells in a column that have a specific value in a cell in their row

问题描述

我的表如下...

Timestamp | Category   | Cost 
--------------------------------
...       | Shopping   | 5
...       | Charity    | 10
...       | Dining     | 20
...       | Mortgage   | 1000
...       | Dining     | 30
etc...

我需要的是每个类别值的公式，获取具有该类别的行的成本列的总和。即。我可以在我的预算表中的实际支出单元中放置该类别的总支出。数据输入一个谷歌表单，所以我几乎没有权力的格式化。

What I need is a formula for each category value that will get the sum of the cost column for rows that have that category. ie. total spending in that category that I can place in the "actual spending" cell in my budget table. The data is input with a google form so I have almost no power over formatting.

感谢您的帮助！

推荐答案

您可以使用多个SUMIF （）函数将这些总和放在电子表格的任何位置。假设列A为时间戳，列B为类别，列C为成本：

You could use multiple SUMIF() functions to place these sums anywhere in the spreadsheet. Assuming Column A is TimeStamp, Column B is Category, and Column C is Cost:

Shopping -> =SUMIF(B:B, "Shopping", C:C)
Charity  -> =SUMIF(B:B, "Charity", C:C)
Dining   -> =SUMIF(B:B, "Dining", C:C)
Mortgage -> =SUMIF(B:B, "Mortgage", C:C)

这篇关于在其行中的单元格中具有特定值的列中的Sum单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！