1. I want the formula installed in the sheel called "SumTotals".
2.Please install the formula in the first row (staring with B4
ending AH4) of the SumTotals sheet. The formula should
be adding the B8 cell locations from the sheets (1 thru 350) I
and I will do the rest 365 rows myself for January thru December.
3. The cells start from B8 through AH8. All the sheets have the same
If you get the first row working, in the "SumTotals" sheet, I think I can do the rest 365 rows as long as I will be able to copy and edit your formula.
The first row cells of the SumTotalS are in this order:
B4, D4, F4, H4, J4, L4, N4, P4, R4, T4, V4, X4, Z4, AB4, AD4, AF4, & AH4
The first row cells of the Sheets are in this order:
B8, D8, F8, H8, J8, L8, N8, P8, R4, T8, V8, X8, Z8, AB8, AD8, AF8, & AH8.
In other words your formula in the SumTotals sheet cell locations should be reading =zSUM("sheet1","sheet350","B8") in location B4, =zSUM("sheet1","sheet350","D8") in location D4,=zSUM("sheet1","sheet350","F8") in location F4...=zSUM("sheet1","sheet350","AH8") in location AH4.
John, I am a pastor trying to help churches with this program. I will appreciate it if we can get this program right: I have pastor friends who have seen the demonstrations of the program and are waiting for it for their financial record keeping.
Thank you and God bless