Microsoft Office Forums - View Single Post - [Solved] How do you add values in a column when determining the lowest amount within multiple groups

wheddingsjr · 09-07-2018, 07:01 AM

Thanks NoSparks

This was VERY helpful. Unfortunately though, the highest number should not calculate and populate, its only those that are less than it. I am not sure what you mean by "confirmed with Shift+Ctrl+Enter not just Enter and drag down". I thought perhaps thats why the high number is being populated because when I do the "Shift+Ctrl+Enter not just Enter nothing happens.