In Column F on the attached, I want to get the weighted average of the difference between column D and column E. For example, F4 shows a 3.55% increase YOY. What's the overall weighted average?
Thanks.
In Column F on the attached, I want to get the weighted average of the difference between column D and column E. For example, F4 shows a 3.55% increase YOY. What's the overall weighted average?
Thanks.
=(sum(e4:e20)-sum(d4:d20))/sum(d4:d20)
try this
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks