Countifs More than 1 Criteria

[hardeep.kanwar]

Dear All,

I have two Sheets 1 have Master another have Summary

I need Countif Formula to Count Multiple Count form Master File

Like If Column A in Master Sheet have data of Column B in summary Sheet,Then take the Count of NRE and CB from Column G from Master Sheet

I am using this Formula , But its not Working

COUNTIFS(Master!$a$2:$a$1803,b7,Master!$g$2:$g$1803,"NRE",Master!$a$2:$a$1803,b7,Master!$g$2:$g$1803,"CB")

<colgroup><col></colgroup><tbody>
</tbody>

 

[Robert Mika]

=SUM(COUNTIFS(master!$A$2:$A$1803,B7,master!$G$2:$G$1803,{"NRE","CB"}))

 

[hardeep.kanwar]

=SUM(COUNTIFS(master!$A$2:$A$1803,B7,master!$G$2:$G$1803,{"NRE","CB"}))

Perfect and Thanks

 

[Robert Mika]

Perfect and Thanks

You are welcome