Home > Back-end >  Google sheets Query >= function not working
Google sheets Query >= function not working

Time:08-17

I am trying to make a simple dashboard to get data from one sheet to show if it is greater than a week in cell B2

=QUERY('KPI 14 - 26'!A1:CC14,"select A, sum(F), sum(D), count(D) where A is not null AND A >= '"&B2&"' group by A")

This code doesn't throw an error, but just doesn't display any date. If I change >- to contains it will show one weeks data. How can I fix this so that it shows all the data in weeks > week b2?

All of the data in column A on my data sheet are numbers (14 to 26)

CodePudding user response:

use:

=QUERY('KPI 14 - 26'!A1:CC14,
 "select A,sum(F),sum(D),count(D) 
  where A is not null 
    and A >= "&B2*1&" 
  group by A")
  • Related