Hi,
I need a macro that will find the last row in column "I" and insert a SUMIF formula for:
=SUMIF(C2: Row above where this formula in "C" column, "C" in row of this formula, I2: Row above where this forumla is entered)
The last row will vary in each of the sheets this is being done on. It will do this three times on each sheet but I want the ranges to stay the same ...
For example sheet one:
Example sheet two
I32 I will need the SUMIF to be input... which would be end range would be different
=SUMIF( C2:C31, C32, I2,I31 ) =SUMIF( C2:C44, C45, I2,I44 )
I33 I will need a SUMIF input with same ranges just different criteria
=SUMIF( C2:C31, C33, I2:I31 )=SUMIF( C2:C44, C46, I2,I44 )
I34 same again
=SUMIF( C2:C31, C34, I2:I31 ) =SUMIF( C2:C44, C47, I2,I44 )
How would this be done in macro form for the sum if formulas?
Bookmarks