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.

In the Excel sheet below, in the first table, you can see two numbers 10 and 5, which is our data. In the other table, you can see the operations to be carried out by applying appropriate formulas.

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.