Jun 10 2021 10:03 PM
Jun 10 2021 11:50 PM - edited Jun 10 2021 11:57 PM
A point of clarification - that type of formula used to work inside a structured table. But, when MS pushed the update for office 365 to implement dynamic array as the default formula evaluation method, it no longer works and you have to enter the formula as Riny indicated.
I think that some teachers and textbooks are not up to date on the latest Excel version, so it is possible it may work for the instructor, but not the students (depending on what version each is using).
Edit: Though I think there should be an extra set of brackets around Account Values.