Monday, October 29, 2018

yogi_Compute Sum Of Hours For Persons By 'Name' And 'Surname' From Specified Date (say TODAY) Onward

Google Spreadsheet   Post  #2532

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-29-2018
Advanced SUMIF taking into account dates
Hello!!
As a continuation of the following post: https://groups.google.com/a/googleproductforums.com/d/msgid/docs/8763004d-6d90-4574-86a8-498021b955c4%40googleproductforums.com.

I'm trying to do SUMIFs across a whole sheet with two cells conditions.

This is the timings of people on day by day basis, and I want to get a summary within that spreadsheet that calculates the timings for each individual (they have name and surname across two different cells) but now I would like for the QUERY function to take into account the current date (e.g. A16:C22).

e.g. https://docs.google.com/spreadsheets/d/1T8p0VZ1VhTBA72LNTMwyYujy1o6WsDV5r_AW_lAmVQ8/edit?usp=sharing

Ben Liebrand mentioned is not a good idea to use merged cells, but how would you design it?

Also, Would it be possible to show the sum values but also add a breakdown of the hours showing the dates (e.g. A8:E13).?



Can anyone help?

Cheers!!!

No comments:

Post a Comment