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
