SUMIFS within Date Range

@A Rose

Let's start with logic and syntax. You want this formula to add up the values in the [Average Rating] column for rows where the [Current Date] value is between the [From Date]# summary column value and the [To Date]# summary column value, yes?

If so, you need to utilize greater than/less than and use the two date summary fields as separate criteria; we can do that by adding the AND function. You also listed your summary field as the range to add up, I think you meant to put the range for the Average Rating column:

=SUMIF([Current Date]:[Current Date], AND(@cell >= [From Date]#, @cell <= [To Date]#), [Average Rating]:[Average Rating])

In English: Add up the values in the Average Rating column where the Current Date value is greater than or equal to the value in the From Date summary field, and also less than equal to the value in the to Date summary field.

Give that a shot.

I was wondering about that. You want the average of all the averages. Gotcha. That's a different function: AVERAGEIF

You'll have to try it an see if it works the same. It looks like it does, but like many things in Smartsheet, your mileage may vary!

=AVERAGEIF([Current Date]:[Current Date], AND(@cell >= [From Date]#, @cell <= [To Date]#), [Average Rating]:[Average Rating])