Hi,
You can also add total for each month change by subtotal.
<table style="padding-right: 2pt; padding-left: 2pt; font-size: 11pt; font-family: Calibri,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="font-weight: bold; width: 30px;"> <col style="width: 68px;"> <col style="width: 64px;"> <col style="width: 64px;"> <col style="width: 85px;"> <col style="width: 64px;"> <col style="width: 99px;"></colgroup> <tbody> <tr style="font-weight: bold; font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td> <td>date</td> <td>payee</td> <td>ref no</td> <td>total income</td> <td>GST</td> <td style="font-weight: bold;">Helper column</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td> <td style="text-align: right;">1/1/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">697</td> <td>
</td> <td style="font-weight: bold; text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td> <td style="text-align: right;">1/25/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">498</td> <td>
</td> <td style="font-weight: bold; text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td> <td style="text-align: right;">1/30/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">819</td> <td>
</td> <td style="font-weight: bold; text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td> <td style="text-align: right;">2/1/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">602</td> <td>
</td> <td style="font-weight: bold; text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td> <td style="text-align: right;">2/15/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">285</td> <td>
</td> <td style="font-weight: bold; text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td> <td style="text-align: right;">2/28/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">74</td> <td>
</td> <td style="font-weight: bold; text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td> <td style="text-align: right;">3/1/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">479</td> <td>
</td> <td style="font-weight: bold; text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td> <td style="text-align: right;">3/10/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">203</td> <td>
</td> <td style="font-weight: bold; text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">10</td> <td style="text-align: right;">3/30/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">521</td> <td>
</td> <td style="font-weight: bold; text-align: right;">3</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 252, 249);"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="font-size: 9pt; font-family: Arial;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="font-size: 10pt; background-color: rgb(202, 202, 202);"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>F2</td> <td>=MONTH(A2)</td></tr> <tr> <td>F3</td> <td>=MONTH(A3)</td></tr> <tr> <td>F4</td> <td>=MONTH(A4)</td></tr> <tr> <td>F5</td> <td>=MONTH(A5)</td></tr> <tr> <td>F6</td> <td>=MONTH(A6)</td></tr> <tr> <td>F7</td> <td>=MONTH(A7)</td></tr> <tr> <td>F8</td> <td>=MONTH(A8)</td></tr> <tr> <td>F9</td> <td>=MONTH(A9)</td></tr> <tr> <td>F10</td> <td>=MONTH(A10)</td></tr></tbody></table></td></tr></tbody></table> create helper column&extract month using month function.
use subtotal function alt+d+b
with each change in helper column being selected &suming total income or any column you wish to add up.
Output
<table style="padding-right: 2pt; padding-left: 2pt; font-size: 11pt; font-family: Calibri,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="font-weight: bold; width: 30px;"> <col style="width: 68px;"> <col style="width: 64px;"> <col style="width: 64px;"> <col style="width: 85px;"> <col style="width: 64px;"> <col style="width: 99px;"></colgroup> <tbody> <tr style="font-weight: bold; font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;"> <td>
</td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td> <td>F</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">1</td> <td>date</td> <td>payee</td> <td>ref no</td> <td>total income</td> <td>GST</td> <td style="font-weight: bold;">Helper column</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td> <td style="text-align: right;">1/1/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">697</td> <td>
</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td> <td style="text-align: right;">1/25/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">498</td> <td>
</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td> <td style="text-align: right;">1/30/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">819</td> <td>
</td> <td style="text-align: right;">1</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: right;">2014</td> <td>
</td> <td style="font-weight: bold;">1 Total</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td> <td style="text-align: right;">2/1/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">602</td> <td>
</td> <td style="text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td> <td style="text-align: right;">2/15/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">285</td> <td>
</td> <td style="text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">8</td> <td style="text-align: right;">2/28/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">74</td> <td>
</td> <td style="text-align: right;">2</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">9</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: right;">961</td> <td>
</td> <td style="font-weight: bold;">2 Total</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">10</td> <td style="text-align: right;">3/1/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">479</td> <td>
</td> <td style="text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">11</td> <td style="text-align: right;">3/10/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">203</td> <td>
</td> <td style="text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">12</td> <td style="text-align: right;">3/30/2011</td> <td>
</td> <td>
</td> <td style="text-align: right;">521</td> <td>
</td> <td style="text-align: right;">3</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">13</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: right;">1203</td> <td>
</td> <td style="font-weight: bold;">3 Total</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">14</td> <td>
</td> <td>
</td> <td>
</td> <td style="text-align: right;">4178</td> <td>
</td> <td style="font-weight: bold;">Grand Total</td></tr></tbody></table>
<table style="border-style: groove; border-color: rgb(0, 255, 0); font-size: 10pt; color: rgb(0, 0, 0); font-family: Arial; background-color: rgb(255, 252, 249);"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="font-size: 9pt; font-family: Arial;" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="font-size: 10pt; background-color: rgb(202, 202, 202);"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>F2</td> <td>=MONTH(A2)</td></tr> <tr> <td>F3</td> <td>=MONTH(A3)</td></tr> <tr> <td>F4</td> <td>=MONTH(A4)</td></tr> <tr> <td>D5</td> <td>=SUBTOTAL(9,D2:D4)</td></tr> <tr> <td>F6</td> <td>=MONTH(A6)</td></tr> <tr> <td>F7</td> <td>=MONTH(A7)</td></tr> <tr> <td>F8</td> <td>=MONTH(A8)</td></tr> <tr> <td>D9</td> <td>=SUBTOTAL(9,D6:D8)</td></tr> <tr> <td>F10</td> <td>=MONTH(A10)</td></tr> <tr> <td>F11</td> <td>=MONTH(A11)</td></tr> <tr> <td>F12</td> <td>=MONTH(A12)</td></tr> <tr> <td>D13</td> <td>=SUBTOTAL(9,D10:D12)</td></tr> <tr> <td>D14</td> <td>=SUBTOTAL(9,D2:D12)</td></tr></tbody></table></td></tr></tbody></table>