SUM and SUMIFS are just two of the SUM functions in Excel. You can specify up to 127 range/criteria pairs in a SUMIFS statement.

You can subtract in Excel by placing a minus sign in front of any numbers you want to deduct. You can add and subtract a bunch of numbers at once using the equal sign or SUM function.

The First 8 Excel Tricks You Have To Learn On The Way To Becoming A Master By Walt Hickey Jul 10, 2013, 5:32 PM PT Flickr/Microsoft Sweden Excel is the best piece of software ever made.