CountIf for a range with multiple criteria
 

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco

CountIf for a range with multiple criteria
 

=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))

Better to put the "TT" & "1" in cells e.g X1, X2:

=SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2))

"Marco" wrote:

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco

CountIf for a range with multiple criteria
 

Hello. I couldn't put this working, but tell me, what happens if the TP has
also 0 on column B?

Regards,
Marco

"Toppers" wrote:

=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))

Better to put the "TT" & "1" in cells e.g X1, X2:

=SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2))

"Marco" wrote:

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco

CountIf for a range with multiple criteria
 

TP is ignored.

Is column B text or numberic: if text change 0 to "0".

Worked fine for me ... what result did you get?

"Marco" wrote:

Hello. I couldn't put this working, but tell me, what happens if the TP has
also 0 on column B?

Regards,
Marco

"Toppers" wrote:

=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))

Better to put the "TT" & "1" in cells e.g X1, X2:

=SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2))

"Marco" wrote:

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco

CountIf for a range with multiple criteria
 

....numberic???? ...numeric!

"Toppers" wrote:

TP is ignored.

Is column B text or numberic: if text change 0 to "0".

Worked fine for me ... what result did you get?

"Marco" wrote:

Hello. I couldn't put this working, but tell me, what happens if the TP has
also 0 on column B?

Regards,
Marco

"Toppers" wrote:

=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))

Better to put the "TT" & "1" in cells e.g X1, X2:

=SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2))

"Marco" wrote:

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco

CountIf for a range with multiple criteria
 

It worked, thanks a lot.

Regards,
marco

"Toppers" wrote:

...numberic???? ...numeric!

"Toppers" wrote:

TP is ignored.

Is column B text or numberic: if text change 0 to "0".

Worked fine for me ... what result did you get?

"Marco" wrote:

Hello. I couldn't put this working, but tell me, what happens if the TP has
also 0 on column B?

Regards,
Marco

"Toppers" wrote:

=SUMPRODUCT(--($A$1:$A$4="TT"),--($B$1:$B$40))

Better to put the "TT" & "1" in cells e.g X1, X2:

=SUMPRODUCT(--($A$1:$A$4=X1),--($B$1:$B$4X2))

"Marco" wrote:

Hello. I want to make a count concerning two columns A and B.

The column A has text such as TT and TP the column B has numbers.

example
A B
TT 2
TP 5
TT 0
TT 1

I need to count how many times I have TT on columns A that the value on
column B is higher then 0

How?

Regards,
Marco