I am trying to automatically add up each expense based up on the table. What formula would I use if I wanted to add up all my travel expenses from the information on my table?
- ∅Lv 71 month ago
just click the sigma symbol Σ to Autosum, while you have the cell underneath that column selected.
- MarvinatorLv 71 month ago
You could use SUMIF for this
=SUMIF(F2:F34, "Travel", D2:D34)
This looks up the word "TRAVEL" in the F Column and then adds the corresponding amounts from the D column.