On 2002-10-11 15:03, Dartagnan wrote:
Can you do a sumif with 2 or more criteria? I would like the sumif to look at 2 cells and then sum. For example cell A1 has 1/2001 and cell C1 has 6. I want the sum if A1 = 1/2001 and C1 = 6.
Can this be done?
On 2002-10-11 15:34, Dartagnan wrote:
I am not sure I follow you. I am going to look through 2 columns and if the criteria in both columns match then give me the sum.
The 1st criteria(1/2002) is located in column A. The 2nd criteria(6) is located in column C. The column I want to sum is column B. So if column A has 1/2001 and column C has 6 then give me the sum from column B.
Thank you.