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.

Could someone help me please?

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.

Could someone help me please?

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

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. Could someone help me please?

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. 

Could someone help me please?