Hi All,

Can anyone to help me to check what is wrong with my formula, I want to get the exact count of tested to the Step Counter Tab (column Total per Resource). Unfortunately, I am not getting the same total count in total per resource and tested. I am using below formula

Please see the screenshots the results from excel.

=SUM(COUNTIFS('MDD_Activity v.02'!$O:$O,'Step Counter'!$A2,'MDD_Activity v.02'!$P:$P,'Step Counter'!B$1,'MDD_Activity v.02'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS(MCIv3.1!$O:$O,'Step Counter'!$A2,MCIv3.1!$P:$P,'Step Counter'!B$1,MCIv3.1!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('General Features'!$O:$O,'Step Counter'!$A2,'General Features'!$P:$P,'Step Counter'!B$1,'General Features'!$K:$K,{"Passed";"Failed";"Blocked"}), COUNTIFS('MDD_Dining v.01'!$O:$O,'Step Counter'!$A2,'MDD_Dining v.01'!$P:$P,'Step Counter'!B$1,'MDD_Dining v.01'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('Web Check-in'!$N:$N,'Step Counter'!$A2,'Web Check-in'!$O:$O,'Step Counter'!B$1,'Web Check-in'!$J:$J,{"Passed";"Failed";"Blocked"}),COUNTIFS('MDD_BarAndLounge v.01'!$O:$O,'Step Counter'!$A2,'MDD_BarAndLounge v.01'!$P:$P,'Step Counter'!B$1,'MDD_BarAndLounge v.01'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('Login v2.1'!$O:$O,'Step Counter'!$A2,'Login v2.1'!$P:$P,'Step Counter'!B$1,'Login v2.1'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('DreamElite v3.1'!$O:$O,'Step Counter'!$A2,'DreamElite v3.1'!$P:$P,'Step Counter'!B$1,'DreamElite v3.1'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('MMB v.01'!$O:$O,'Step Counter'!$A2,'MMB v.01'!$P:$P,'Step Counter'!B$1,'MMB v.01'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('Admin Portal'!$O:$O,'Step Counter'!$A2,'Admin Portal'!$P:$P,'Step Counter'!B$1,'Admin Portal'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('VC VK vTest Summary Tab.jpg2.3'!$O:$O,'Step Counter'!$A2,'VC VK v2.3'!$P:$P,'Step Counter'!B$1,'VC VK v2.3'!$K:$K,{"Passed";"Failed";"Blocked"}), COUNTIFS('MDD_Facilities v.02'!$O:$O,'Step Counter'!$A2,'MDD_Facilities v.02'!$P:$P,'Step Counter'!B$1,'MDD_Facilities v.02'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('MDD_iCafe v.01'!$O:$O,'Step Counter'!$A2,'MDD_iCafe v.01'!$P:$P,'Step Counter'!B$1,'MDD_iCafe v.01'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('MDD_Shorex v.01'!$O:$O,'Step Counter'!$A2,'MDD_Shorex v.01'!$P:$P,'Step Counter'!B$1,'MDD_Shorex v.01'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('MDD_Casino v.01'!$O:$O,'Step Counter'!$A2,'MDD_Casino v.01'!$P:$P,'Step Counter'!B$1,'MDD_Casino v.01'!$K:$K,{"Passed";"Failed";"Blocked"}),COUNTIFS('MDD_MyWallet v.01'!$O:$O,'Step Counter'!$A2,'MDD_MyWallet v.01'!$P:$P,'Step Counter'!B$1,'MDD_MyWallet v.01'!$K:$K,{"Passed";"Failed";"Blocked"}))Step Counter Tab.jpg