# Numbers formula for rolling 12 month sum

I have a table with income data over a 2 year period showing columns: date, description, job1, job2, job3, (the income shown is for 3 different work jobs over a period of time).

In a separate table I would like to calculate my income over a rolling 12 month period but can't work our how to do it.

here are the simplified tables, so with this basic data I can do the basic sum (as sown). but in the complete table 1 there are hundreds of entries so I need a formula to calculate the figures in table 2 please. needs to be a rolling 12 months figure for each heading. thank you

• Can you show a sample of the data in the first table and also describe how the calculation needs to look like in a bit more detail, preferably again with a ”sample”? Commented Feb 22, 2020 at 20:41
• The `SUM` function comes to mind. We need some more information however. Does each row in the table correspond to a month or the end of a pay period? As @Alper pointed out, a sample (screenshot or otherwise) is needed. Commented Feb 22, 2020 at 23:28

``````= SUMIFS(Table 1::E\$2:E\$7,Table 1::\$A\$2:\$A\$7,">="&\$A5,Table 1::\$A\$2:\$A\$7,"<="&\$B5)