How to list unique values under a parent row, and summarize in the same cell
Is it possible to list the unique values listed under a parent cell, and give a sum of the values, all in the same cell? When I set my sheet up, I though the "Funded Work Items" would stay the same each month, so right now my sum in the blue, calls the funded work items in the month of October.
Here's a sample of it:
"=[Vehicle/Boat/ATV Number]4234 + ": $" + SUMIF([Funded Work Item]4233:[Funded Work Item]4389, [Vehicle/Boat/ATV Number]4232, Cost4233:Cost4389) + " YTD" +"
What I'd like, is to be able to have it list the unique values for the whole year, and then list the sum of that "cost". Is this possible? I'm willing to get creative with it. I just don't want it to be so hard coded as it is right now. Thank you!
Help Article Resources
Check out the Formula Handbook template!