Google Sheets query function based on multiple rows and/or columns

Question

Please assist a newbie with a query about query where 1 = Total Gross or Employers Cost based on the department and pay period.

So from the Data Sheet to a query on another sheet, I would be able to select February and Data it would produce Column C, D, I & J

Thanks in advance

what have you actaully tried? This looks quite straight forward...? Also post what you are expecting to be the output based on your parameters. — pgSystemTester
– pgSystemTester, Commented Sep 9, 2022 at 0:15
share a copy / sample of your sheet with an example of the desired output — player0
– player0, Commented Sep 9, 2022 at 0:24

Osm · Accepted Answer · 2022-09-09 08:54:49Z

1

Use this formula

=QUERY(Sheet1!A:J, "Select A, C, D, I, J Where A = '"&$B$3&"' ", 1)

Demo

answered Sep 9, 2022 at 8:47

Osm

2,9112 gold badges8 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.