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?