CODEWITHSUNDEEP
excelvbaloopsrows
Stokie
Stokie

Reputation: 1

VBA loop to repeat an Excel Calc over multiple row

Evening Boffins,

I think I have what you will find a relatively easy question.

I would like to repeat the excel calc below on circa 200 rows in excel and sum the result;

=IF('By Project'!$AM$40>0.01,'By Project'!$AM$40*'By Project'!G$40,0)

Any help greatly appreciated

Thanks Newbie

Upvotes: 0

Views: 88

Answers (1)

Tim Williams
Tim Williams

Reputation: 166331

Something like:

=SUMPRODUCT(--(AM1:AM200>0.01),(AM1:AM200*G1:G200))

Upvotes: 1

Related Questions