Search Results
Search type | Search syntax |
---|---|
Tags | [tag] |
Exact | "words here" |
Author |
user:1234 user:me (yours) |
Score |
score:3 (3+) score:0 (none) |
Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
Views | views:250 |
Code | code:"if (foo != bar)" |
Sections |
title:apples body:"apples oranges" |
URL | url:"*.example.com" |
Saves | in:saves |
Status |
closed:yes duplicate:no migrated:no wiki:no |
Types |
is:question is:answer |
Exclude |
-[tag] -apples |
For more details on advanced search visit our help page |
Use for questions about QUERY built-in function from Google Sheets.
0
votes
1
answer
46
views
How may I add an average count of rows by weekday to this example Google Sheets
Here is an example Google Sheet that summarizes Col A, D by weekday totals and counts.
I would like to add an Average number of items by Weekday, like K9 L9 but show it in formula K1.
There are two(2) …
1
vote
1
answer
2k
views
How to show Day of Week in Order by Day of Week in Google Sheets
I have the following formula that displays a total by Day of Week (weekday) from a date in J and amount in K
Example
J contains 1/1/2020 ... until 9/29/2020
K contains numeric value 123 ... 1999
=Quer …
1
vote
1
answer
79
views
Can a formula cell reference be a variable cell reference?
Assuming I insert every day some rows into Sheet1, this formula stops working and I have to manually edit every day --- can the reference to Cell A2 and Cell E2 be a variable that remains hardcoded as …
0
votes
1
answer
261
views
Method to preserve cell reference in a formula upon adding rows in reference sheet?
I have a Google Sheets with two(2) tabs. The first sheet is just a running tally of raw data and is updated with new rows at the top weekly.
In tab 2 there is just a single query(arrayformula)... tha …
0
votes
3
answers
4k
views
Can Weekday value be shown in natural (Su, Mo, Tu..) format in Array Formula?
For Google sheet with the following data in A2:B4
06/29/2019 1:25 PM 1
06/30/2019 1:32 PM 1
07/01/2019 1:40 PM 1
The output will show
Monday 1 1
Saturday 1 1
Sunday 1 1
Can this be Sat …
2
votes
2
answers
503
views
How do I get the count number of weekdays in a datetime column in Google Sheets?
I have a timestamp in mm/dd/yy hh:mm:ss format from January to March. How do I count "how many days are Monday" in the range of A1:A199? (Or How Many are Tuesday, Wednesday, Saturday?
This gives me a …