Table is a function that was introduced in either excel 2002 or 2003, it
has been removed in 2007
But I'm still using Excel 2003. Can't understand why it now doesn't work.
My original worksheet where DSUM was used was with Excel earlier than
2002.

I have just tried your suggestion using SUMIF, replacing Dividend_Range
with a column of figures for H2 and got all zeros in column I. Thought
perhaps changing $A$4:$A$50 to A4:A50 for the Company_Range might work
but again they all turned out to be zero. Did you actually get it to
work for you? Appreciate your help.


Yes I got it to work, I can email you a little sample workbook if you
want?
That will be great. Shall test it with Excel 2003 and let you know.
Thanks.


Is the yahoo address you are using here your real email address?
Anyway, I sent a sample to that address



--


Regards,


Peo Sjoblom