| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 Computergaga | 2015-05-05 22:12:52 |  45,133 Views |
This video demonstrates a list of incoming and outgoings. To sum the expenses in the list we need to sum only the negative values.
Learn over 100 different formulas with our online course.
https://goo.gl/QlMrkK
Sum negative numbers only in Excel using the SUMIF function. Using this function allows us to specify a condition for the values to add.
To use the SUMIF function you just need to supply the range of cells to test, the criteria and the range of cells to sum.
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
