How to sum range only data in current month?
for instance;
<tbody>
</tbody>
I want dynamically sum the range A:L but the result should only count from first (A) to the current month (Aug), how do I achieve this goal?
for instance;
A | B | C | D | E | F | G | H | I | J | K | L |
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
1 | 0 | 0 | 2 | 4 | 5 | 0 | 0 | 8 | 9 | 0 | 2 |
<tbody>
</tbody>
I want dynamically sum the range A:L but the result should only count from first (A) to the current month (Aug), how do I achieve this goal?