This video shows you how to calculate weighted average cost from a transactional data set using SUMPRODUCT function. It explains things very clearly. If you're working with a very large database transactions the SUMPRODUCT function makes it. It works as text if you do the formatting first and then type the number. We put the number in first and then format as text, then press F2 and ENTER.
It’s Cyber Monday on WonderHowTo! Don’t miss out on all the big sales in the Gadget Hacks shop and Null Byte shop. Use code CMSAVE20 to save on everything, and use CMSAVE40 for all things apps and software. For online courses, apply code CMSAVE70 for the biggest discounts.