| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional/variable sum??
Hi, I am trying to sum the sales values of months (say Jan to Mar) with the
start month being fixed and the end month being a variable. I have therefore named a cell as my EndMonth and want my sum to change automatically every time I change my EndMonth variable. ie. if the sales values for Jan to Dec are in range B2 to M2, I want my sum to change automatically from B2:D2 for the period Jan to Mar to B2:G2 for the period Jan to Jun. Is there a function for this? I tried Index for no luck. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Sum - variable criteria | Excel Discussion (Misc queries) | |||
| Conditional Formatting using variable text | Excel Discussion (Misc queries) | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
![Costas Limassol[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
