Shazam
09-15-2006, 09:53 AM
Hi everyone,
I would like to input this formula at the bottom of the data in column Y
=SUMPRODUCT(--(B2:B74=1),--(Y3:Y75>0),Y3:Y75)
I wrote this code but It does not work. I must be missing like a quote or something.
FinalRow = Range("A65536").End(xlUp).Row + 1
Range("Y" & FinalRow + 1).Formula = "=SUMPRODUCT(--(B2:B" & FinalRow & "=1"""") " _
& ",--(Y3:Y" & FinalRow + 1 & ">0""""),Y3:Y" & FinalRow + 1 & ")"
Any Help.
I would like to input this formula at the bottom of the data in column Y
=SUMPRODUCT(--(B2:B74=1),--(Y3:Y75>0),Y3:Y75)
I wrote this code but It does not work. I must be missing like a quote or something.
FinalRow = Range("A65536").End(xlUp).Row + 1
Range("Y" & FinalRow + 1).Formula = "=SUMPRODUCT(--(B2:B" & FinalRow & "=1"""") " _
& ",--(Y3:Y" & FinalRow + 1 & ">0""""),Y3:Y" & FinalRow + 1 & ")"
Any Help.