I am working for a webhosting company and we are tracking our efforts with Google Sheets.

I was trying to find a solution for the following problem:

We track our efforts by clients per day, so that they can be invoiced individually. So for one day I have a list of several clients I have worked for today with a column of start time, one for end time and one for the time I worked for this client.

When invoicing clients I have to look through the whole sheet for every client and look up manually how long I have been working for them.

Is there a way I can simplify this process? I am thinking of a field in the sheet which give me the effort I had with this client. Something like:

If(B2 = "client1", Sum(H1;H90))

Important about this: I work for several clients each day. So I need a way to check in one column for the client name and then sum the efforts up in a several fields.

  • 2
    You may want to check out the filter() function or the query() function. If you need more helps, share some example data and the expected outcome.
    – JPV
    Oct 29, 2015 at 11:12
  • 2
    Take a look to the SUMIF function. Oct 29, 2015 at 15:53
  • Hi guys, sorry for not responding the last days. I have made an example sheet, so maybe you can help me with that. docs.google.com/spreadsheets/d/…
    – Fabian
    Nov 2, 2015 at 11:37
  • Check out my answer below Apr 7, 2016 at 19:08

1 Answer 1


Are you looking for something like this?


or if you want it more dynamic, for example if you want to have one cell that you can choose which client you want to see hours for, then alter the part that says "client2", to point to a single cell in which you will put the client you want to see.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.