vladzhogol
New Member
- Joined
- Dec 8, 2015
- Messages
- 5
I'm having trouble creating a COUNTIFS function with the following information:
*Criteria_range1: "AvgSummer"(column R) values on "OlympicMedals" worksheet
*Criteria 1: Greater than or equal to "Tier" values in "Summer" (column D)
*Criteria_range2: "AvgWinter" (column S) values on "OlympicMedals" worksheet
*Criteria 2: Greater than or equal to "Tier" values in "Winter" (column E)
I'm not sure how I should write the Criteria 1 and 2 for this function.
Please Help!!!!
*Criteria_range1: "AvgSummer"(column R) values on "OlympicMedals" worksheet
*Criteria 1: Greater than or equal to "Tier" values in "Summer" (column D)
*Criteria_range2: "AvgWinter" (column S) values on "OlympicMedals" worksheet
*Criteria 2: Greater than or equal to "Tier" values in "Winter" (column E)
I'm not sure how I should write the Criteria 1 and 2 for this function.
Please Help!!!!