In this example the dates are captured in rows 8 to 14 and column 2, therefore, if you are capturing the dates in different rows you will need to change the From and To i values in the VBA code.
HOW TO SUM A COLUMN IN EXCEL BASED ON MONTH CODE
Output Range: Select the output range by changing the cell reference ("F7") in the VBA code to any cell in the worksheet that doesn't conflict with the formula.ĭate: Select a range that captures the dates that you want to test against by changing the i values that represent the row range and the value of 2 in the Cells reference that represents the column reference. In this example we have specified for the For Loop to loop through rows 8 to 14 in column 3 to find all of the values associated with the dates that fall into the third month (March). This is especially important for the For Loop to loop through specified rows and columns. Values: If using the exact VBA code you will need to capture the values that you want to sum that are associated with the specified month in range ("C8:C14"), which is the column next to the dates.
In this example we have specified for the For Loop to loop through rows 8 to 14 in column 2 to find all of the dates associated with the third month (March). Worksheet Name: Have a worksheet named Analysis.ĭates: If using the exact VBA code you will need to capture the dates that you are testing against in range ("B8:B14").
0 kommentar(er)
