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
Are you trying to sum by week. If so you can try something like this:
In cell B2, filled down:
=SUMIFS(Table 1::C,Table 1::A,">"&A2−7,Table 1::A,"<="&A2)
Use ; instead of , in the formula if your region uses , as the decimal separator. The amounts in your column C should be right-aligned by default if Numbers is recognizing them as numbers rather than text.
Note that in Numbers you refer to the whole column A not with A:A (as you have, probably because you may be used to that in Excel) but with A. When entering the formula let the formula editor do the work. If you select the entire column the formula editor will enter the A for you.
SG
Hello georby,
it would really help if you could post a screenshot of your table.
The function DAY will return the day for one cell only and not for a column!
Are talking about August 1st to August 7th or do you mean weekday Monday to Sunday?
These answers will help to support you
Regards Ralf
Please find the screenshot. I want to find the sum of “Amount” column of the dates between 1 January and 7 January.
Numbers iOS SUMIFS with date range.
