View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
emerson.farms emerson.farms is offline
external usenet poster
 
Posts: 2
Default Assistance with advanced formulas

I am attempting to simplify the time sheet for a client. She has multiple
clients that she works for and enters time on a single sheet. I need to set
up a formula on a new sheet that will look through the entries in 2 columns
of her original time sheet and calculate the time for each client (2 of her
clients have multiple services with different charges). The end result will
give total hours & charges for each client (the 2 with multi services would
have subtotals and a grand total).

original sheet looks like this
date service client hours

need to show this info on new sheet
client service total hours cost


Any assistance would be greatly appreciated.
I can send someone a sample xls if it would help.

Thank you.