Using Countif or other with two conditions

[maic15]

Below, is a countif() that I'm using to summarize my data on "Summary 2" worksheet.

=COUNTIF('MA, SY and PL Tracking'!$A$10:$A$146,"G")

I need to add another condition to this statement, but do not know how to join two Countif() statements.

Here is the other statement:

=COUNTIF('MA, SY and PL Tracking'!S10:S145,"X")

 

[Aladin Akyurek]

Below, is a countif() that I'm using to summarize my data on "Summary 2" worksheet.

=COUNTIF('MA, SY and PL Tracking'!$A$10:$A$146,"G")

I need to add another condition to this statement, but do not know how to join two Countif() statements.

Here is the other statement:

=COUNTIF('MA, SY and PL Tracking'!S10:S145,"X")

You omitted to stipulate the way you need them to "join". Likely...

=SUMPRODUCT(--('MA, SY and PL Tracking'!$A$10:$A$146,"G"),--('MA, SY and PL Tracking'!S10:S146,"X"))

At Edit:

=SUMPRODUCT(--('MA, SY and PL Tracking'!$A$10:$A$146="G"),--('MA, SY and PL Tracking'!S10:S146="X"))

 

[DominicB]

Good evening maic15

Download and install my add-in via the link below. Once installed, select Ultimate > Formulae > Multiple SumIf Generator. This will enable you to build a formula using SumProduct that will count the cells based on criteria of your choosing.

HTH

DominicB

 

[maic15]

I tried both options above and I'm getting a #value error? WHat am I doing wrong?

 

[Brian from Maui]

I tried both options above and I'm getting a #value error? WHat am I doing wrong?

Care to post the formula you're using? The ranges must be of the same size.

 

[maic15]

I solved the problem. If the ranges contain no data, then #value will occur.

Thanks!

This tools is very slick!

 

[Brian from Maui]

I solved the problem. If the ranges contain no data, then #value will occur.

No data in the ranges should not return an error.

 

[Aladin Akyurek]

I solved the problem. If the ranges contain no data, then #value will occur.

Thanks!

This tools is very slick!

=SUMPRODUCT(--('MA, SY and PL Tracking'!$A$10:$A$146="G"),--('MA, SY and PL Tracking'!S10:S146="X"))