Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Jonathan
Jonathan asked in Computers & InternetOther - Computers · 1 year ago

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

Relevance
  • ?
    Lv 7
    1 year ago

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

  • Marvinator
    Lv 7
    1 year 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 your answers by asking now.