Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Google sheets Query >= function not working

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?

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

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

>Solution :

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")
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading