One way:

=(B5=B21)*((A5=A22)*C5 + (A6=A22)*C6)




In article ,
"peter via OfficeKB.com" wrote:

I want to create two or more functions to works in one cell, respectively:

IF(AND(B5=B21,A5=A22),SUM(C5),"") and IF(AND(B5=B21,A6=A22),SUM(C6),"")
Independently they work but when I’m ordering one by one in sell appears
FEALS.
I tried to apply before OR , IF(OR …. , but something’s wrong.