"Peo Sjoblom" wrote in message
...

Are you somehow trying to get all results in one fell swoop,

Yes, that was what I got before. The worksheet with an old database shows
precisely that. The first cell shows the formula,
=DSUM(Database,"Dividend",C869:D870) whereas every cell below it shows
{=TABLE(,C870)}. Must have been entered as for an array because it won't
allow me to edit it. Hence, I want to start everything all over again but
have forgotten how the DSUM formula was entered down the column. Just
copying it down won't work.


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.

Regards,
Tom