| 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) |
| 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 | |||
Threaded Mode
