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