Dears,
I have cloulmns for prices & others for volume (lets now focus on two columns E&O (E10:15 & O10:O15) , wherein E for prices & O for volume, I need to calculate the weighted average prices of the last 6 months but the issue each column has #N/A, my question is how to calculate the weighted average without including #N/A?
please help me.
Bookmarks