MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

Posted by Aladin Akyurek on August 17, 2001 3:22 PM

Did you try: $F$2:$F$3537 and $G$2:$G$3537? (NT)

Posted by giohess on August 21, 2001 8:08 AM

Re: Did you try: $F$2:$F$3537 and $G$2:$G$3537? (NT)

Thank you very much.