Is there a way I can add a total of a column if the numbers are imported from a different sheet with google sheets? and matching a pair of dates?

=SUMIFS($S$8:S47,$O$8:$O47,">="&T$51,$O$8:$O47,"<="&$V$51)

CodePudding user response：

most likely this is the issue of QUERY. query likes to "assume" the type of dataset (numeric/plain text) and 90% of time it assumes it wrongly so you either end up with empty columns or missing values. use in S6:

=IMPORTRANGE("1nC7e8za4_SjIAbPsRv4loQ8CHinwcp0J43LcyG0qopM", "August 2022!i3:j45")