Google Spreadsheet Post #1876
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Jan-03-2015
post by health professional guy:
https://productforums.google.com/forum/#!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.
------------------------------------------------------------------------------------------------------------------------------
https://productforums.google.com/forum/#!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.
------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment