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