I am using Excel 2010 to track purchases. I have 2 sheets in one workbook
and need to do a SUMIF that has 3 conditions.

Condition 1 is Status=€�processed€� (Column B)
Condition 2 is Quarter (1,2,3 or 4) (Column D)
Condition 3 is Line Item (€œItem1€�, €œItem2€�, etc.) (Column L)

The dollar amount is in Column J.


If the conditions on sheet2 are met then it will sum the dollar amount in
Sheet1.

How can I do this?

thank you.