How can I calculate Rows with the specific value from a dataset. I have data like the table below. I want to find how many 'A' are there with jon in diffrent column. I tried 'Count' with if statment, didn't work.

[Tushar Patel]

Column 1

Column2

Column 3

 

 

X1

Jon

A

 

 

X2

Jon

A

 

 

X3

ket

A

 

 

X4

Jon

B

 

 

X5

ket

A

 

 

X6

jon

B

 

 

X7

ket

A

 

 

X8

Mar

A

 

 

X9

Gir

A

 

 

 

I have data like the table below. I want to find how many 'A' are there with jon in diffrent column. I tried 'Count' with if statment, didn't work.

[Richard Pobi]

I think using Count is the best way but the below expressiom works fine.

SUM (if(([Col2]="jon") and ([Col3]="A"),1,0)) over [Col1]

[Tushar Patel]

Thanks Richierich