I have a SUMPRODUCT calculation set up to to a weighted avg of 3 months
of data, for a quarter summary.
[[=IF(W24="","",SUMPRODUCT(W24:Y24,J24:L24)/SUM(J24:L24))]]

My question is this: If one of my months has no data (empty cell),
does this mess up the avg? Does the sumproduct count that cell as a 0,
bringing down the avg? I know that AverageA takes that into account and
has a workaround, but I don't know if this function does. Help!

Thanks,

Perry


--
PerryClisbee
------------------------------------------------------------------------
PerryClisbee's Profile: http://www.excelforum.com/member.php...o&userid=37120
View this thread: http://www.excelforum.com/showthread...hreadid=568536