Forum Discussion
Complex Formula/Lookup and total
I need assistance. I need to calculate the total number of man hours spent on multiple jobs from my file for the entire year to see which project(s) had the most hours sent. So I have multiple projec...
Presuming the first column is for 'Projects', all you really need is a pivot table to summarize.
If you prefer a formula, you could use a dynamic array:
=LET(
UniqueProjects, SORT(UNIQUE(Project)),
totals, SUMIF(Project, UniqueProjects, ManHours),
HSTACK(UniqueProjects, totals)
)
Your GROUPBY with the eta-reduced Lambda function worked perfectly.
- Glad it worked! Not even tested as I don't have access to Insider's at work.