Numbers iOS SUMIFS with date range.
I’m trying to find sum of a column (E:E) on a weekly basis. So, I have a column for date (A:A).
The following is the formula I tried, but it seems like I’m missing something.
I believe the range of DAY formula returns multiple values and hence the condition causes the error. What I want is to find the sum of column E if and only if the day of date in column A falls between 1 and 7.
SUMIFS(E:E,DAY(A:A),“>0”
,DAY(A:A),”<8”)
iPhone 13 Pro, iOS 17