So I am struggeling with a simple formula which doesn't seem to work..
I want the average of an column from a quarter . Its scores, so i want the average of the total scores (8.4, 8.5, 10 etc.) over this quarter. The formula i am using :
AVERAGE(DATE_STARTOF( DATE( B:B , "MM/dd/yyyy" ), "quarter"),D:D;)
The result I get is a string of all the scores. Not an average. Could someone help me out? I know this is something small..