I’m trying to create a sheet that lists entries depending on the month. As seen in the code below, I want it to look for which month is selected on the Summary sheet (in cell H2) and then display the correct data from the Data sheet according to the correct month (months are listed in column A)

=QUERY(Data!A2:$E,"where month(A) 1=Summary!H2:$H AND E = 'Expense'", 1)

I’m not sure if this is possible with query as I’m pretty sure it needs to be a numerical value after the = in the month condition

CodePudding user response：

try:

=QUERY(Data!A2:E, "where month(A) 1="&MONTH(Summary!H2)&" and E = 'Expense'", 0)

where Summary!H2 is a numeric number from 1 to 12