Excel 2007 : SUMIFS & month value

**78Idyll** · 11-22-2011, 05:06 PM

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

**daddylonglegs** · 11-22-2011, 05:13 PM

Assuming you put the first formula in B2 then try this

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