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!