Suppose that you want to get a sum of past-due invoice amounts or ones associated with the Oregon office. In other words, the value in the Amount range will be summed if either of the following criteria is met:

• The corresponding value in the Difference range is negative.
• The corresponding text in the Office range is “Oregon”.

This example requires an array formula:

{=SUM(IF((Office=”Oregon”)+(Difference<0),1,0)*Amount)}

A plus sign (+) joins the conditions; you can include more than two conditions.

• L Shaped Desks - Perfect For Any Home Or Office L shaped desks are most suitable for a various office solutions. These desks are called L shaped for a fine...
• Payday Loan Advancing Nearly everyone is trying to get in on payday loans. The concept of the loans is to provide fast cash...
• Make Landscape Changes to Your Country Garden Although fall and winter are upon us, and most gardeners think having a garden is now out of season, it...
• The Complete Steelheader: Successful Fly-fishing Tactics User Reviews Send this to a friend The Complete Steelheader: Successful Fly-fishing Tactics Manufacturer: Stackpole Books Customer Rating: List Price:...
• Avoid The Financial Trap Of A Reverse Mortgage If you and your spouse are both over 60 and your house is completely paid off, you may have considered...