Hi, I need help with a formula for finding the maximum of several sums.
I'm given a list of different diagnoses that can all be found in column A. Within each diagnosis, there are several different procedures, about 8 different ones, and over 5 for each different one, column B, that could be performed, and associated with each individual procedure is a price. I need to figure out which procedure had the highest total price for the given diagnosis. So I know I need to do some sort of max and sum, but I'm not sure how to do the sum without summing up each procedure code. Is there a way to find the sum for every procedure code in one shot?