needing a formula to place in 6 cell locations in each of the 12 monthly sheets that is the total for that income.
I have a workbook with 12 worksheets named, "Jan" - "Dec", each sheet has 6 cells for income totals 1-6 i.e. F3 - F8
I keep income in a worksheet named "Income" with 5 columns, example;
Worksheet "Income" row 1 is a header row and has this format
"A" | "B" | "C" | "D" | "E"
Income |Date |From |Deposit To|Amount
--------------------------------------------
RMDs 1/4/2019 Source 1 Bank 1 10.50
RMDs 1/4/2019 Source 2 Bank 2 8.00
RMDs 1/6/2019 Source 1 Bank 1 4.50
DADs 1/8/2019 Source 3 Bank 1 12.10
DADs 1/10/2019 Source 4 Bank 3 2.10
RMDs 2/3/2019 Source 1 Bank 1 9.10
DADs 2/4/2019 Source 3 Bank 1 7.15
Misc 2/4/2019 Source 5 Bank 3 9.50
and so on for each month,
Worksheet "Income" column "E" contains amounts, am needing a formula I can use for the Monthly Sheets Jan - Dec, Income totals 1-6
Jan Income #1 totals cell = F3
Jan Income #2 totals cell = F4
...
Jan Income #6 totals cell = F8
Same income cells for all other month sheets
This had a previous solution, the Income sheet column requirements have changed slightly, previous solution was
and I used this formula in income cells 1-6 and only needed to change the last F3 to F4, F5, F6, F7, F8 for the other incomes. this worked for all 12 sheet months. Thanks in advancePlease Login or Register to view this content.
Bookmarks