Macro SUMIF range increases by one if run from cell below
Posted by giohess on August 17, 2001 3:14 PM
I have a spreadsheet where dollar amts are identified by type. At the end of the sheet I will record a macro to sumif the dollar amt is a certain type. Example: =SUMIF(F2:F3537,6,G2:G3537). If I go to the cell below and run the macro my range increases by one, (F3:F3538,6,G3:G3538). If I choose a cell 5 rows down my macro changes to (F7:F3542,6,G7:G3542). I want the macro to retain the original range as I recorded it. What am I doing wrong?