Sumifs + this month going backwards????

[natheplas]

Hi,

I have put together the following formula:

=SUMIFS(POINFO!$E$41:$E$9682,POINFO!$A$41:$A$9682,[@[STOCK CODE]],POINFO!$F$41:$F$9682,"Oct-2017")

Is it possible to have a formula like above, but includes Oct-2017 and then goes back through the months to Jan-2017.

Then for Nov-2017, it will add up Nov 2017 back to Jan 2017.

Then also for example Dec 2017, will go back to Jan 2017.

As I add the column in for the month, I need it to also include any previously outstanding purchase orders for that code, on the previous months.

Please let me know if you need more information.

Struggling with this one!

 

[natheplas]

I essentially need to know how to include previous months with my sum if formula please?

Or if there's an easier / better way to do it, I'm open to it.

Really appreciate anyone's help with this.

 

[natheplas]

Sorted it! I was over complicating something very simple.

occam's razor...