how do i add repeated data together
i have a table where clients information such as time spent on job, amount charged, net cost, and net profit are listed each time we provide a service for them
each table runs for 2 weeks, so need to find a formula that will consolidate all the data from the 2 weeks into one table. For example
in a 2 week period we may service a client 3 or 4 times, so i need the new table to show a list of all the clients served and the data for each client to be added together to show the total for all services provided in that 2 weeks to be added together.
any help much appreciated.