| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
a problem with if invovling a range of cells
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) |
|
#2
|
|||
|
|||
|
See other post
Biff "Anthony" wrote in message ... 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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
| sumproduct of part cells of a range with blanks | Excel Discussion (Misc queries) | |||
| range and cells syntax | Excel Worksheet Functions | |||
| sum a range of cells that include an error | Excel Discussion (Misc queries) | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
Linear Mode
