May be this......
Sorry I completely missed the question.![]()
K3 =IF(AND(SUM(E6:E7)=SUM(E9:E13),SUM(E9:E13)=SUM(E15:E16),SUM(E15:E16)=SUM(E18:E19),SUM(E18:E19)=SUM(E21:E22)),SUM(E6:E7),"Check")
The correct one is as below......
![]()
E4 =IF(AND(SUM(E6:E7)=K3,SUM(E9:E13)=K3,SUM(E15:E16)=K3,SUM(E18:E19)=K3,SUM(E21:E22)=K3),K3,"Check")
Bookmarks