| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problem with an "if" relating to a range
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
| autofilter problem | Excel Worksheet Functions | |||
| Defined range difficulty | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
Threaded Mode
