Try this€¦

If you want only to show C1 value when A1 & B1 values are matching then use
this formula
=IF(OR(A1="",B1=""),"",IF(A1=B1,C1,"A1 & B1 IS NOT MATCHING"))

If you want to sum A1 to C1 when a1 & b1 values are matching then use this
formula
=IF(OR(A1="",B1=""),"",IF(A1=B1,SUM(A1:C1),"A1 & B1 IS NOT MATCHING"))

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"naveeenc" wrote:

Hi,
How to put multiple Criterias in Sum if formula???

If the data in A1 & B1 matches as per the criteria, it should add Cell C1...