Hi everyone

I am working with SUMIFS formula for the yearly report; column headers have months and row headers have the customer names.

I made the formula for the first cell and copy/pasted it into the rest of the cells in the first row.

Is there a way to make the month value in the below formula increase so that when I copy / paste the formula into the next column cell it shows as 2 (as in February)?

=SUMIFS(Sales[Net weight];Sales[Material];47010226;Sales[Month];1;Sales[Name of sold-to party];"ABC company")

Because right now I am manually changing the months in each cell.
I am hoping that there is an easy way.

Thank you