I’m trying to expand the countif formula listed below to count specific score values, ranging from 500 to 900, for 8 participants.
For example:
Current formula I’m using is
COUNTIF (‘INDIVIDUAL RESULTS’! AE2:AE85, “>=499”)
The results are contained in another worksheet titled “INDIVIDUAL RESULTS covering lines 2 to 85 across 8 columns. Looks like this
AC
Line 2-700 score
3-655
4-528
5-612
85-682
So I’m trying to create separate formulae that will be displayed in 4 separate colums (500-600-700-800)for each individual for each of the following ranges:
>=500 <=599 count only in that range AE2:AE85
>=600 <=699 same AE2:AE85
>=700 <=799 same AE2:AE85
>=800 <=899 same AE2:AE85
So can the original “COUNTIF” formulae be expanded to count > and > occurrences?
Bookmarks