Hi Monique,

If your formula is good, try this :

you just have to put your formula into brackets on the same line and you will get your result in your variable.

Dim MyVar As Double

MyVar = [If(SumIf(F10:AJ10, F10, F23:AJ23)*D100,SumIF(F10:AJ10, F10, F23:AJ23),(SumIF(F10:AJ10, F10, F25:AJ25)/SumIF(F10:AJ10, F10,
B57:AF57))*(C25/K25))]


Salutations!




"Monique" a écrit dans le message de news: ...
I have to code a formula in vba.. it is below:

If(SumIf(F10:AJ10, F10, F23:AJ23)*D100, SumIF(F10:AJ10, F10, F23:AJ23),
(SumIF(F10:AJ10, F10, F25:AJ25)/SumIF(F10:AJ10, F10, B57:AF57))*(C25/K25))

I need to simplify this because I am going to be putting the formula in VBA.
I just don't know how to handle the many SumIf statements.

Any advice would be great.

Thanks