It doesn't look as if you can simplify it if you want to maintain the IF
test, but why do you need to put it in VBA, and what difficulties are you
envisaging? Will you write the formula to a cell within VBA, or evaluate the
formula?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Monique" wrote in message
...
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