| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thinking that indirect should work
What I want to do in the formula below is to have the $F$4 be variable going from F4 to F369 (and yes $B$4 will have to changes as well) =SUMPRODUCT($F$4:$F$370,--(MONTH($B$4:$B$370)=$O14)) Tried a couple of times and couldn't make it work- what do you recommend? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect - Why does it seem to only work sometimes? | Excel Worksheet Functions | |||
| Summarizing field quantities for specific records | Excel Worksheet Functions | |||
| INDIRECT function do not work when other file is closed | Excel Discussion (Misc queries) | |||
| Why does this Formula work? | Excel Worksheet Functions | |||
| Some Excel links don't work | Excel Discussion (Misc queries) | |||
Linear Mode
