I have an excel workbook that does lots. I am currently trying to do the following:
1. summarize values in one worksheet based on a pull down value in another. The sumif works.
2. determine the highest value of a list of values based on that pull down value.
3. determine the lowest value greater than 0 of a list of values based on that pull down value.
4. determine the average value for each category.
I have attached the workbook and the "Summary" worksheet is where I am reporting these values.
Cell C7 (DM) is the pulldown cell. All of the data is pulling from the Accounting List worksheet. If I filter by DM column on the Accounting list and check the high (large), low (small), and average, I get different numbers. I tried doing a vlookup but could only return the first number that met the condition and couldn't get it to find the smallest, largest, or average of the vlookup range.
Any help will be greatly appreciated.
Bookmarks