Hi Howard,

Am Sat, 6 Dec 2014 09:04:44 -0800 (PST) schrieb L. Howard:

I would think both SumProduct and Values would be the proper method to use. That is unconfirmed to me at present.

if the user inserts rows with values you better work with formula. The
formula modifies automatically.
Do you have the newest version of the workbook? I had a little error in
the first one I uploaded.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional