Turn Sumproduct Calculation Into vba

Hi,

I have this calcualtion in G4 on a worksheet. Is there a way to get a macro to put this calculation into G4 and copy it to bottom of the data the range of which moves up and down on a monthly basis?

=SUMPRODUCT((Download!I4:I54862="CUSTOMER1")*(Download!H4:H54862=CUSTOMER1!H4)*(Download!G4:G54862))

I have come up with this but it doesn't get around the range problem. i.e. 54858 needs replacing with siommething like lrow.

Please Login or Register  to view this content.