srizki
Well-known Member
- Joined
- Jan 14, 2003
- Messages
- 1,844
- Office Version
- 365
- Platform
- Windows
I used these formula to sum by months, but I realized that not all dates are on the first day of the month, there for it did not work.
Can some one help me by providing a formula that sums on the base of range date or rather month.
thanks.
Can some one help me by providing a formula that sums on the base of range date or rather month.
thanks.
YTD August FA and GL.xls | ||||||
---|---|---|---|---|---|---|
D | E | F | G | |||
1433 | TotalForAugust | 3,405,503.26 | ||||
1434 | TotalForJuly | 2,945,583.84 | ||||
1435 | TotalForJune | 6,933,994.76 | ||||
1436 | TotalforMay | 9,996,888.58 | ||||
1437 | TotalforApril | 11,025,035.74 | ||||
1438 | TotalforMarch | 3,620,218.39 | ||||
1439 | TotalforFebruary | 4,319,309.93 | ||||
1440 | TotalforJanuary | 8,322,190.62 | ||||
AUGUST YTD FA |