Sumif 2 conditions

Hello Abdul,

Hope you enjoyed your Microsoft Excel Advanced course with BEST Training.
Thank you for your question regarding SumIf function with two different conditions.

Unfortunately, the answer is that SumIf can not handle two different conditions.

In order to do two conditions, you have to use a rather complicated array formula. The conditional sum wizard add-in allows you to enter these complicated formulas with ease.

I hope this resolves your question. If it has, please mark this question as resolved.

Regards,

Richard