Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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

Posted on Aug 20, 2023 4:00 PM

Reply
3 replies
Sort By: 

Aug 21, 2023 8:21 AM in response to georby

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

Reply

Aug 21, 2023 1:50 AM in response to georby

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


Reply

Numbers iOS SUMIFS with date range.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.