General summary total by item

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CleverCat - 20 Nov 2006 22:30 GMT

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

Reply to this Message

Pete_UK - 21 Nov 2006 00:57 GMT

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

> I have a timesheet recording activity against client for a day. (E.g. ColA:
> Client code, B: hours)
[quoted text clipped - 8 lines]
> Thanks for nay help
> James

Reply to this Message