Sumif formula won't drag down to bottom row

Hi,

I'm using the following formula in B2 of my worksheet to calculate message volume by month from another worksheet.

=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!C$16:C$63)
When I drag the formula to the next row down (B3) the formula just repeats itself

How can I get B3 to be
=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!D16:D63) and so on by dragging down?

When i use
=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!C16:C63) the output on B3 is
=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!C17:C64)

The formula works fine if I drag across columns but I need it to go down instead of across.

Thanks!

you mean COLUMN not row

remove the "$" from the criteria range

=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!A$36,'Msg Volume Detail'!D16:D63)

But the highlighted range will change if you drag across

Perhaps

=SUMIF('Msg Volume Detail'!$A$16:$A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!$C$16:$C$63)

This is dragging down not across as the ROW increments

=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!C16:C63) the output on B3 is
=SUMIF('Msg Volume Detail'!A$16:A$63,'Msg Volume Detail'!$A$36,'Msg Volume Detail'!C17:C64)

so which is? it??

You need to understand the difference between relative and absolute range

the "$" fixes a range: either row, column or both

Tony thank you that worked!