I am attempting to use the COUNTIF function to count multiple criteria from a database.
I want to count all of column "A" if the criteria are met in Columns G, H,AX,V
I have tried the below function so far, which returned a zero value.
If column G = Apples or Oranges, then count column A.
=COUNTIFS('DIS'!$A$:$A$,A$21,'DIS'!$G$:$G$,$AC$12&"_"&$AC$15)
I want to count all of column "A" if the criteria are met in Columns G, H,AX,V
I have tried the below function so far, which returned a zero value.
If column G = Apples or Oranges, then count column A.
=COUNTIFS('DIS'!$A$:$A$,A$21,'DIS'!$G$:$G$,$AC$12&"_"&$AC$15)