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

question by: msmariaavlarez
https://productforums.google.com/forum/#!topic/docs/iKNdC2HkjTc;context-place=mydiscussions

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!!!

Concrete Placement In Basement ICF Walls Of New House In Michigan -- ANAND Enterprises Project HomA1J1805

.
Concrete was placed on Oct-26-2018 by Michael Hanes Of Homes American Made between 11:30 AM and 5:00 PM. Following are some pictures taken during the concrete pour,

Engineering Evaluation For Permanent Foundation For Manufactured House In SouthEastern Michigan -- ANAND Enterprises Project SteK1J1801

I was at the project site today to look at this good looking manufactured home to confirm that the manufactured home has indeed been installed on a permanent foundation. The owner/builder wants to refinance the house and it is a HUD requirement that a manufactured home has a permanent foundation.

Engineering Evaluation Of Welded Beam Extension In New House In SouthEastern MI -- ANAND Enterprises Project HunP1J1801

.

I was at the project site on Mar-29-2018 to look at the welded beam extension in the new house under construction in Southeastern Michigan

In the following I present a few pictures that I took during my field visit

Engineering Evaluation Of Plywood Decking Subsequent To Long Exposure To Elements For New ICF House In SouthEastern MI -- ANAND Enterprises Project EneE1Bai_1

.

I was at the project site on Mar-26-2018 to look at the condition of the plywood decking of the house subsequent to long exposure to elements.

In the following I present some pictures of plywood decking that shows some damage, swelling, opening at seams, stripping,cracking etc -- the more severely damaged boards have been marked with a red x. 

ctures that I had during my field visit.

Engineering Evaluation Of Roof Steel Trusses As Installed In New ICF House In SouthEastern MI -- ANAND Enterprises Project EneE1KloM1

.

Based on my field inspection of the trusses as installed, the information provided to me, my engineering judgment, and my practical experience, I found that the trusses have been installed in a workman like manner and will carry all the intended dead and live loads safely and securely.

In the following I present a few pictures that I had taken during my field visit.