The following formula returns the sum of the negative values in column F. In other words, it returns the total number of past-due days for all invoices. For this worksheet, the formula returns –63.

=SUMIF(Difference,”<0”)

Because you omit the third argument, the second argument (“<0”) applies to the values in the Difference range.

You don’t need to hard-code the arguments for the SUMIF function into your formula. For example, you can create a formula, such as the following, which gets the criteria argument from the contents of cell G2:

=SUMIF(Difference,G2)

This formula returns a new result if you change the criteria in cell G2.

• phpSEO - Class for better SEO in PHP I've been working all the free time I had this week in the class to make better SEO in your...
• Excel How-to: The SUMIF Function The SUMIF function is an easy way to get a subtotal of specific data that meets a certain condition, without...
• Buying World's Fair Memorabilia There are an endless variety of different types of collections and memorabilia out there, and one of the options that...
• Should you write your own tax software? Lazy Man and Money posted a reader's question over in the MBN Forums asking for help: Do you have an...
• More Tips for Serving Here are some more useful tennis tips for improving your serving game. If you want to make improvements in your...