Summing entire sheet, but only higher number with similar items.
Okay so I'm trying to create a rough budget for a project, but have received multiple bids for some categories. I want to sum all the items cost, but with multiple items, only take the higher cost.
Here's roughly what I mean:
So I want to sum the price column, but only take the larger number from appliances(or anything with the same name). I know I could make a large Max(collect()) chain within a sum function and write out every item I have duplicates of, but Id like to avoid that. I have a rather lengthy list with several duplicates.
I was wondering if there's a way to create a function to check for duplicates, then maybe use that with max and sum everything.
Thank you to anyone who helps in advance.
Help Article Resources
Check out the Formula Handbook template!