Good job. I'd like to learn more about how to break out of the select string, come back into it, syntax issues, etc. For example, I get an error with this - =query({Eddie!$A1:$H25}, "select sum(Col2) where " & roundup(month( & "Col1" & )/3,0) & " = " & C$6 & " label sum(Col2) '' ", 0). I think my problem is I'm trying to pull Col1 into the month function. I already broke out of the string with the roundup function, but then I need to somehow come back in to reference Col 1 of my range. The roundup and month function together wouldn't work unless I broke out of the string.
Great explanation and good value! Thanks a bunch mate : )
REALLY A NICE VIDEO
Nice video. Thank you
what if there are entries like montana, michigan, etc but their countries are Canada in column I, how can i filter those not "United States"
thanks
Good job. I'd like to learn more about how to break out of the select string, come back into it, syntax issues, etc. For example, I get an error with this - =query({Eddie!$A1:$H25}, "select sum(Col2) where " & roundup(month( & "Col1" & )/3,0) & " = " & C$6 & " label sum(Col2) '' ", 0). I think my problem is I'm trying to pull Col1 into the month function. I already broke out of the string with the roundup function, but then I need to somehow come back in to reference Col 1 of my range. The roundup and month function together wouldn't work unless I broke out of the string.