"SB Lee" wrote:
I just must be doing something wrong because the 2nd and 3rd rows returned a
value but the rest are zero.

I don't know. The expressions given should work fine. You'd have to re-check
carefully your source data, eg in col Q there could be some non-numerics
(text, not text nums), residual errors? etc. Use the autofilter droplist on
col Q to quick-screen through the list and rectify.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---