Hi!

What is the *exact* formula that you used?

could it be that E29 to E41 and d7 are all dates showing as Jul 05 etc

That should not make any difference. If they were all dates or if they were
all just text strings that would not make a difference. If D7 was a text
string and E29:E41 were true dates or vice versa, the formula would return
an incorrect result but not a #VALUE! error.

Are the values in C29:C41 and B5 really numbers?

The only things that will cause a #VALUE! error are if the values in C29:C41
or B5 are really TEXT or if the range sizes are not the same.

Biff

"Anthony" wrote in message
...
could it be that E29 to E41 and d7 are all dates showing as Jul 05 etc

"Biff" wrote:

Hi!

Try this:

=SUMPRODUCT(--('Cattle Mvts'!E29:E41='Cattle Budget'!D7),'Cattle
Mvts'!C29:C41)*'Feedlot Assumptions'!B5

Biff

"Anthony" wrote in message
...
May not have explained my problem clearly enough so here it is again,
hopefully someone is able to help.The formula below works well for a
set
scenario

=IF('Cattle Budget'!D7='Cattle Mvts'!E29,'Cattle Mvts'!C29*'Feedlot
Assumptions'!B5,0)

however what I now need is that if the date in D7 is equal to the date
showing in any of E29 to E41 then multiply the corresponding row in the
C
column by B5, and add them all togther.

Hopefully someone can help
thanks
anthony