Google Spreadsheet Post #2532
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Oct-29-2018
question by: msmariaavlarez
https://productforums.google.com/forum/#!topic/docs/iKNdC2HkjTc;context-place=mydiscussions
https://productforums.google.com/forum/#!topic/docs/iKNdC2HkjTc;context-place=mydiscussions
Hello!!
As a continuation of the following post: https://groups.google.
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).
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/
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!!!
