Microsoft Array/SUMIF question?

Question: Basically I'm trying to use the SUMIF function or an array function to get a sum with two different range criteria. My example is I'm summing depreciation based on asset life, AND the year that it was put into use. So I am looking for a function that will gather all assets put into use in 2005 with a useful life of 5 years, and then give me the sum.

Or as another example:

For Auto Insurance, Column A is fault (ours, theirs), Column B is Who Paid (Our company, other company), Column C is the amount paid that I need summed.

I probably just confused everyone that read this, so just tell me and I'll elaborate.

Answer:
This is an old issue, you got these options:
1- Using the two functions SUM and IF, yes use =SUM(IF(... to get the conditions done, but instead of pressing Enter, you need to press CTRL+SHIFT+ENTER to enter it as array
2- Use another column having IF function with the criteria you want, showing Zero if the two conditions does not work, and showing the amount you want to sum if both conditions are TRUE.
3- Using Autofilter or Advanced filter can do the same trick.
4- And you always can use DSUM, it is in Database functions and can work like Advanced filter.

E-mail me if need any more info, Read my profile, I am XLMan

---

More Questions & Answers...

Do I need to get new auto insurance?

What concerns you more the price of gas or the cost of Insurance which has increaed 30% higher then gas.?

Does my auto liability insurance cover me while driving a rental car?

I have to ask all.. Because State Farm insurance will not cover Mississippi..Do you trust State farm anymore?

On average, what does it cost to add a teen to your auto insurance?

I was in rear-end auto accident, not my fault. I still owe $. Will other party's ins be liable to pay?

Heard of an auto insurance company called DIRECT?

Auto Insurance Adjuster?