Forum Discussion
JokerMartini
Nov 08, 2021Copper Contributor
Create query displaying sum and count and totals
I have a timesheet where every entry has a Category, and total number of hours spend on that task. It looks like this... How can i create a query/summary on another sheet in my excel doc...
HansVogelaar
Nov 08, 2021MVP
If you have Microsoft 365 or Office 2021, you can use dynamic array formulas: