Saturday, January 3, 2015

yogi_Compute Total Hours By Client For Each Day And Highlight Hours If More Than 6

             Google Spreadsheet   Post  #1876
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-03-2015
post by  health professional guy:!category-topic/docs/spreadsheets/zcthk9LzpI0
How can I create a screen to find a sum by filtering two columns at once?
Attached is a mock up of my sheet.

I would like to create a code that checks the total hours billed to the same client each day.  So the filter must first find the same date (column A) then find all the entries for each client (Column C) then check the total number of hours billed to that client for that day (in Column F).  THEN, ideally, it would create a warning if the total was more than 6 hours.

So the code has to be able to first check the date, then add up the total hours billed for all 5 clients simultaneously, and flag it if any of the totals for that day is above 6 hours.

I hope I'm being clear. I'm thinking this is possible but involves matrix/array/transposing type coding that is way beyond my understanding. Thanks for any help.