a problem with if invovling a range of cells

A

Anthony

If the date in D7 equals any of the dates showing in E29 to e41 then multiply
the corresponding row in the c column by b5 and add them together to appear
in this cell

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with an "if" relating to a range 7
Sum product help needed with an extra variable please and thankyou 6
sumif depending on 2 cells matching 3
Advanced 'SUMPRODUCT' formula - MAX or LARGE?? 4
SUMPRODUCT - enhanced formula 1
Cell referencing 1
Return Value from a Range (depends on input to determind month) 2
Summing values for a range of dates 2

Top