I have two sheets (tabs) in an excel document, Sheet 1 and 2. As can be seen below Sheet 1 has 3 columns [1 row], and Sheet 2 has 2 columns [5 rows].
I am looking for a formula that will return the values that is in Sheet 1, Column C (i.e. 3). I am able to do a countif formula to find the count of the item in Sheet 1, Column A; but what formula would work to get the value of dates that are equal to or greater than 2013 in Sheet 2, Column B.
Sheet 1
Column A:Item Column B:Count Column C:=>2013
1. P02853 5 3
Sheet 2
Column A Column B
1. P02853 2014
2. P02853 2011
3. P02853 2015
4. P02853 2013
5. P02853 2010
How can I return a count of a specific criteria in a range of duplicated items?