4rfvgyhnjik
New Member
- Joined
- Jan 29, 2010
- Messages
- 7
Can someone tell me if it is possible to shorten this formula
=AA8*$AE$3+AC8*$AF$3+AD8*$AG$3+AE8*SUM($AE$3:$AG$3)+AF8*SUM($AE$3:$AF$3)+AG8*SUM($AE$3,$AG$3)+AH8*SUM($AF$3:$AG$3)+AB8*($AF$3/2)
=AA8*$AE$3+AC8*$AF$3+AD8*$AG$3+AE8*SUM($AE$3:$AG$3)+AF8*SUM($AE$3:$AF$3)+AG8*SUM($AE$3,$AG$3)+AH8*SUM($AF$3:$AG$3)+AB8*($AF$3/2)