In my excel i have below column heads
What I am trying to do is count records based on Field_AC using "COUNTIFS" function
I also want to add one more criteria based on Source (Loc4) using the CountIfs function
attach image shows the result of the 1st criteria is 1 each for Field_AC and Loc4.
How can i use both these functions together.