promotion image of download ymail app

Excel Question?

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?

Attachment image

2 Answers

  • Lv 7
    1 month ago

    just click the sigma symbol Σ to Autosum, while you have the cell underneath that column selected.

    • Commenter avatarLog in to reply to the answers
  • 1 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. 

Still have questions? Get answers by asking now.