Use vba to add sumproduct formula's to range

VegasNath · Post by **VegasNath** » 16 Mar 2010, 14:57

I need to (using vba) populate cells F2:F18 with the following formula, where each one looks at the relevant row (C, D, B 2:18)

=IF(C2="",0,SUMPRODUCT((((Rejections!$D$301:$D$10000=C2)*(Rejections!$B$301:$B$10000=D2)))*((Rejections!$J$301:$J$10000))))

How is the best way to achieve this?

Thanks for any help.

Post by **HansV** » 16 Mar 2010, 15:09

Range("F2:F18").Formula = "=IF(C2="""",0,SUMPRODUCT((((Rejections!$D$301:$D$10000=C2)*(Rejections!$B$301:$B$10000=D2)))*((Rejections!$J$301:$J$10000))))"

The row reference will be adjusted automatically.

VegasNath · Post by **VegasNath** » 16 Mar 2010, 15:59

You are a legend! :Thankyou:

You actually gave me the wrong answer...... but as usual, that's because I asked the wrong

question!

rory · Post by **rory** » 16 Mar 2010, 16:08

So it was actually the right answer to the wrong question?

VegasNath · Post by **VegasNath** » 16 Mar 2010, 16:23

No, I figured out the right answer after wasting another 30 minutes of my life..... grrrr

Eileen's Lounge

Use vba to add sumproduct formula's to range

Use vba to add sumproduct formula's to range

Re: Use vba to add sumproduct formula's to range

Re: Use vba to add sumproduct formula's to range

Re: Use vba to add sumproduct formula's to range

Re: Use vba to add sumproduct formula's to range