COUNTIFS Function helps us get conditional counts within a range based upon multiple criteria's. It's a enhanced version of it's sister function COUNTIF which also gives us conditional counts but…