Count and text other row

[elmalle]

I want to know when there is a value in the cell, the number of times the value is in a different row and the text that says it.

In the table when there is a value in cell B, I want the number of times it occurs cell A.
So Monday 2 times, Tuesday 1 times and so on

Is this possible?


[TABLE="width: 255"]
<colgroup><col width="113" style="mso-width-source:userset;mso-width-alt:4132;width:85pt"><col width="227" style="mso-width-source:userset;mso-width-alt:8301;width:170pt"></colgroup><tbody></tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Monday
[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Monday[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Tuesday[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

So
Monday 2
Tuesday 1

 

[mrshl9898]

Assuming your day names start in A2

=COUNTIFS(A:A,A1,B:B,"<>"&"")

 

[elmalle]

Assuming your day names start in A2

=COUNTIFS(A:A,A1,B:B,"<>"&"")

Im getting a error with this code.. expression

 

[mrshl9898]

What version of Excel are you running?

*Also realize I said A1 instead of A2, doubt that's causing the issue though.

 

[elmalle]

Excel 2010.. tried it with a2 but still getting the error.. critirium

 

[mrshl9898]

There shouldn't be any problems i'm aware of, is this going in C2? Maybe try =COUNTIFS(A:A,A2,B:B,">0")