Sumproduct Assistance

[jstevens]

I'm having a challenge with the following and must be overlooking the obvious trying to replicate the formula in Cell F5 with a VBA equivalent.

untitled.png

Thanks for taking a look,
John

[HansV]

This is a "trick" use of SumProduct that doesn't work in VBA. (In general , you can't use Application.WorksheetFunction to evaluate array formulas.) You can use SumIf instead:

Result = af.SumIf(Range("A2:A7"), "D0002", Range("C2:C7"))

[jstevens]

Hans,

You made me chuckle. My original plan was to use the "SUMIF".

Many thanks,
John

[teachesms]

Can't help myself here...The SumIf is great! But...
I really like the "Conditional Sum Wizard" to do the work for me...especially if I have more then one condition. Have you tried it before? If not, it is worth a try...
http://microsoftword.biz/PDFS/The%20New ... %20Sum.pdf

Pages 4-5 go over the Wizard.

You may have to go to the Excel Windows Logo...Excel Options...Add Ins...Go button and add the Conditional Sum Wizard to the Formula bar first, as it is not there by default.

[HansV]

The Conditional Sum Wizard helps you create SUMIF formulas in your worksheet. John was trying to use VBA to calculate a conditional sum.