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?

<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>

Monday	1
Tuesday
Monday	1
Tuesday	1

<tbody>
</tbody>

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")