Using COUNTIFS with multiple columns and criteria

[Kthom019]

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)

 

[Aladin Akyurek]

Try...

=SUMPRODUCT(COUNTIFS('DIS'!$A:$A,A$21,'DIS'!$G:$G,{"apples","oranges"}))


​

 

[Kthom019]

Thanks Aladin.

My issue is that using SUMPRODUCT lengthens the processing time. I wanted to avoid using it.

 

[jtakw]

Hi,

I believe SUM will work just as well:

=SUM(COUNTIFS('DIS'!$A:$A,A$21,'DIS'!$G:$G,{"apples","oranges"}))

 

[Kthom019]

Hi,

I believe SUM will work just as well:

=SUM(COUNTIFS('DIS'!$A:$A,A$21,'DIS'!$G:$G,{"apples","oranges"}))

Thanks jtakw.
It does work only when I type the words. I cannot link to a cell. I will type the words. Gracias.

I am also seeking a countif function to fill in for the below:
SUMPRODUCT ('DIS'!$E:$E=A$23)*('DIS'!$H:$H="TRUE")

I have tried the below and it returned zero.
=COUNTIF ('DIS'!$E:$E,'TRUE')

 

[Aladin Akyurek]

Thanks Aladin.

My issue is that using SUMPRODUCT lengthens the processing time. I wanted to avoid using it.

SUMPRODUCT is summing just two figures COUNTIFS delivers. If you need to place Apples and Oranges in cells of their own, say in X2:Y2, SUMPRODUCT would be an admissible choice.

​

 

[Aladin Akyurek]

Try..

=SUMPRODUCT(('DIS'!$E:$E=A$23)*('DIS'!$H:$H))

if TRUE is not text.
​