Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
automatically updating summary worksheet | Excel Worksheet Functions | |||
Calculating Business Hours Between 2 Dates | Excel Discussion (Misc queries) | |||
calculated item does not work in grand total column in Pivot | Excel Discussion (Misc queries) | |||
My Pivot total just repeats item data | Excel Discussion (Misc queries) |