Hello,
I have a table like this:
<tbody>
</tbody>I'm trying to count how many inputs i have for particular ticker, for particular quarter, with no regard to year.
That is, I want to get an output that shows for
A, Q1= 2
B, Q4= 2
C, Q3= 1
I tried getting a pivot table, but the problem is i don't have unique header names, so I get Q1, Q2, Q3, Q4 and then Q12, Q22, etc...
Is there a way to get countif which looks up criteria range, criteria, and count range, like sumifs?
Thank you!!
I have a table like this:
FY2014 | FY2015 | Count? | ||||||||||
Ticker | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 |
A | 8/13/14 | 11/13/14 | 2/13/14 | 6/26/14 | 8/14/15 | 11/13/15 | 2/13/15 | 2 | 2 | 2 | 1 | |
B | 8/9/1514 | 11/14/14 | 2/13/14 | 6/26/14 | 8/7/15 | 11/13/15 | 2/14/15 | 6/13/15 | 2 | 2 | 2 | 2 |
C | 2/12/13 | 5/10/13 | 8/9/14 | 12/13/14 | 2/10/15 | 5/9/15 | 2 | 2 | 1 | 1 |
<tbody>
</tbody>
That is, I want to get an output that shows for
A, Q1= 2
B, Q4= 2
C, Q3= 1
I tried getting a pivot table, but the problem is i don't have unique header names, so I get Q1, Q2, Q3, Q4 and then Q12, Q22, etc...
Is there a way to get countif which looks up criteria range, criteria, and count range, like sumifs?
Thank you!!