I download a database from an LMS where the courses are organized alphabetically and as a result are randomized from three different levels (tiers) of completion. I am trying to find a way to automatically populate the "hours completed" cells for each level; I can get the total number of classes completed and the total number of hours completed just fine, but this last formula is stumping me.
Bookmarks