simplify formula

[Steven]

does excel (2002 sp2) have built in option to simplify formulas?

=SUMIF(M!$C$13:$C$51,$C3,M!$O$13:$O$51) +
SUMIF('M3'!$C$13:$C$51,$C3,'M3'!$O$13:$O$51) +
SUMIF('M4'!$C$13:$C$51,$C3,'M4'!$O$13:$O$51)

Thanks,
Steve

 

[Steven]

=SUM('M:M4'!$C$13:$C$51,$C3,'M:M4'!$O$13:$O$51)

would this replace the SUMIF? and also include M2?

Thanks,
Steve

=SUMIF(M!$C$13:$C$51,$C3,M!$O$13:$O$51)+SUMIF('M3'!$C$13:$C$51,$C3,'M3'!$O$1
3:$O$51) + SUMIF('M4'!$C$13:$C$51,$C3,'M4'!$O$13:$O$51)

 

[JE McGimpsey]

There is no automatic simplification in XL (other than eliminating
unneeded unary +'s).

I don't see a "simpler" form, though it could be done with one function
call:

=SUMPRODUCT((M!$C$13:$C$51=$C3)*M!$O$13:$O$51 +
(M3!$C$13:$C$51=$C3)*M3!$O$13:$O$51 +
(M4!$C$13:$C$51=$C3)*M4!$O$13:$O$51)

but I think that loses some readability.

 

[Steven]

Thanks for you advice JE,
Steve

There is no automatic simplification in XL (other than eliminating
unneeded unary +'s).

I don't see a "simpler" form, though it could be done with one function
call:

=SUMPRODUCT((M!$C$13:$C$51=$C3)*M!$O$13:$O$51 +
(M3!$C$13:$C$51=$C3)*M3!$O$13:$O$51 +
(M4!$C$13:$C$51=$C3)*M4!$O$13:$O$51)

but I think that loses some readability.