You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
Hello, I will show my example and what I need.
Table 1 row 1-7 I have let's say sum of 10 apples.
Table 2 I have sum of row 1-7 from Table 1.
Now here is what I need, I want to have on table 2 on the next cell sum of table 1 row 8-15, and than I need to use drag formula at table 2 that will sum table 1 but every time 7 rows 1-7, 8-15, 16-23 and so on.
Is it possible on Numbers?
I hope I was clear, thanks.
MacBook Pro 15″, macOS 11.7
Hi shyfromkansas city,
Are you summing apples per week? If so, we can use the SUMIFS function, based upon a date range.
A screen shot of Table 1 will help us to see what you see.
Regards,
Ian.
I'm adding 2 table, table 2 shows by date how many apples per day, table 2 takes sum for the first week and then for the second week, what I need is to drag on table 1 the cell that will sum the next weeks every time 7 days ahead.
Hi shy,
Numbers will not recognise 1-7/8/24 as a date range.
Something like this?
Formula in Table 1 C2 is SUMIFS(Table 2::B,Table 2::A,"≥"&A2,Table 2::A,"≤"&B2)
Regards,
Ian.
Drag formula from table with more than 1 row
