hi,
starting at A6 i have series of dates(sequence of months)
at B6 i have amounts
how do you get the sum of amounts in column B based on current month
add the amount next to the current month down to the last row with data
then show the sum in B3
and show the last date in the row of column A in B4
and make the sum in B3 and the date in B4 to auto update if i add series of date-amount in column A-B
also in row 3
how do you also get the sum of amounts next the cell value "BALANCE" and show the sum in B1 sheet "BALANCE-TOTAL CA"
how do you also get the sum of amounts next the cell value "TOTAL CA" and show the sum in B2 sheet "BALANCE-TOTAL CA"
attached sample file
Bookmarks