| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM a range of sales based on month
Dear All
I am trying to add a specific range of data Column A include a code Column B-X include actual data Culumn X- AI include budget figures. Also in cell A1i have the number of the month For example the month is 3 (March) I want in AK to create a SUMIF where the formula will sum columnsX+Y+Z If month goes 4 then should calculate X+Y+Z+AA and so on Any good ideas? Thanks in advance Manos |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Pull information based on a range of numbers | Excel Worksheet Functions | |||
| Lookup based on range of dates | Excel Worksheet Functions | |||
| Sum based on date range | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on month name | Excel Discussion (Misc queries) | |||
Threaded Mode
