How To Sum By Client

Google Sheets: Summarize Hours Paid and Worked by Client with UNIQUE and SUMIFS This episode shows how to build a per-client summary table in Google Sheets that totals hours paid and hours worked across multiple projects. It demonstrates using the UNIQUE function to list each client once, then using SUMIFS to sum the “hours paid” column for each client by matching the client name as the criterion. It repeats the same SUMIFS approach to total “hours worked” by client by switching the sum range to the worked-hours column. Finally, it calculates an overall difference per client by subtracting total worked from total paid, rather than summing a pre-existing difference column, and notes you could also compute differences with SUMIFS if desired. 00:00 Client Summary Setup 00:09 List Unique Clients 00:21 Sum Paid Hours 01:07 Sum Worked Hours 01:35 Calculate Differences 02:18 Wrap Up and Subscribe