General summary total by item

C

CleverCat

I have a timesheet recording activity against client for a day. (E.g. ColA:
Client code, B: hours)
The client code may have several entries in the day and may vary from
day-to-day.

What I want is a summary of total daily hours for each client. Given that I
may not know which clients I'll be working on in a day, I need a "DISTINCT"
list of client codes derived from ColA with a SUMIF() type process against
hours for each distinct client code.

Thanks for nay help
James
 
P

Pete_UK

Insert a new worksheet then copy column A data (with a heading) to this
second sheet. Then with the data and the header highlighted, click Data
| Filter | Advanced Filter. Your range should already be filled in and
select Unique Records Only and Copy to Another Location (specify C1)
and click OK. Your unique list will appear in column C, and you can
then copy this back to the first sheet to use with your SUMIF formulae.
The second sheet can be deleted if no longer needed.

Hope this helps.

Pete
 
Top