Davers
Well-known Member
- Joined
- Sep 17, 2002
- Messages
- 1,165
Is there anyway to make this formula more efficient? I'm working with weighted averages and this formula is in several hundred cells.....
(((SUM(F80:F81)*F82)+(SUM(H80:H81)*H82)+(SUM(J80:J81)*J82)+(SUM(L80:L81)*L82)+(SUM(N80:N81)*N82)+(SUM(P80:P81)*P82)+SUM(R80:R81)*R82)+(SUM(T80:T81)*T82)+(SUM(V80:V81)*V82)+(SUM(X80:X81)*X82)+(SUM(Z80:Z81)+Z82)+(SUM(AB80:AB81)*AB82))/SUM(F80:AB81)
Thanks,
Dave M.
(((SUM(F80:F81)*F82)+(SUM(H80:H81)*H82)+(SUM(J80:J81)*J82)+(SUM(L80:L81)*L82)+(SUM(N80:N81)*N82)+(SUM(P80:P81)*P82)+SUM(R80:R81)*R82)+(SUM(T80:T81)*T82)+(SUM(V80:V81)*V82)+(SUM(X80:X81)*X82)+(SUM(Z80:Z81)+Z82)+(SUM(AB80:AB81)*AB82))/SUM(F80:AB81)
Thanks,
Dave M.