Geek asks and answers

Sum cells in a column that have a specific value in a cell in their row

My table is as follows:

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

I need a formula for each category value that will get the sum of the cost column for rows that have this category. i.e. total expenses in this category that I can place in the “actual expenses” box in my budget table. Data is entered with a Google form, so I have almost no formatting authority.

Thank you for your help!

+5
source share
2 answers

You can use several SUMIF () functions to place these amounts anywhere in the table. Assuming column A is a TimeStamp, column B is a category and column C is a 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)
+11

, . , . (. 1 .)

, ... . 2. SumIf ( ), J .

enter image description here

+1

More articles:


All Articles