HI! all
In my excel i have below column heads
Field_AC
Source
What I am trying to do is count records based on Field_AC using "COUNTIFS" function
COUNTIFS(K1:K16,G2)
I also want to add one more criteria based on Source (Loc4) using the CountIfs function
COUNTIFS(P1:P16,H7)
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.
Thanks
