Using SUMIF and AND formula together

[Kagesen]

Hi all,

I have a challenge where I require the help of a real expert so thought I would post it here. I think the solution involves using the SUMIF and AND formula together or maybe SUMPRODUCT but I don't know how to set it up correctly. I have extracted a business report from SAP so the data will come out exactly as depicted in attached example so I cannot easily change the format of any dates, numbers or text so your solution should be based on info provided.

My goal is to setup a formula that will give me the value based on certain criteria. For example, if the information in column "A" is "O.QA.SAL.099.PM" and the date in column "C" is between "01.05.2013 to 31.05.2013" then the formula should return value $4,382.68.

I really hope someone can help me here.

Best regards,

Klaus Agesen

[Fotis1991]

SUMPRODUCT is 1 way to go.

=SUMPRODUCT(($A$9:$A$10000="O.QA.SAL.099.PM" )*($C$9:$C$10000>=G1)*($D$9:$D$10000<=G2)*($D$9:$D$10000))

[oeldere]

Pivot table will do the job for you.

See the attached file.

[Kagesen]

Brilliant solutions from both of you. I thank you and have added to your reputation. *hugs*

[Fotis1991]

........................

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[oeldere]

Thanks for the reply.

Glad I could help.

[Kagesen]

Marked as solved. Thanks again.