( by Jeff Wasson )
Have a look at the following screenshot of sheet 'Scorecard':
And I have the following formula in Cell B3:
=query('Response'!A:G;"select B,sum(C),sum(D),sum(E),sum(F),sum(G) where B<>'' and toDate(A)= date '"&text(B2;"yyyy-MM-dd")&"' group by B label sum(C) 'Add Type',sum(D) 'Upgrade Type',sum(E) 'Option 1',sum(F) 'Option 2',sum(G) 'Accessory' ";1)
So now you have a single formula solution, and when you will update the date in cell B2, the data will update on sheet 'Scorecard'