u/Ownership1337

I have a workbook I use to track my daily business earnings and miles among other things and want to be able to reset it to "0" at the tick of a check box. I tried to do some research into IF statements, but I need the formula cell to look at the checkbox and then write into a different cell.

Something like:

    =IF(H28,0,do nothing)

I know this formula doesn't really work and may not make sense, but I want nothing to be done while the checkbox is FALSE, then for the formula or code to write into a different cell, or even a range of cells, if TRUE.

Here is what I am working with, along with my goal restated.

Can I do this with the IF formula, or do I need a more advanced solution?

Excel version: Microsoft® Excel® for Microsoft 365 MSO (Version 2608 Build 16.0.20326.20072) 64-bit

I am using an Excel workbook to track business earnings and expenses for my gig work. Mileage logs for quarters 1 and 2 all fit on one page with room to spare, but Quarter 3 is in excess of the 65 rows I have available in my print area.

I have opted to create an additional sheet for the latter part of quarter 3, but I have run into a slight inconvenience in keeping all references updated to "Sheet 2 of 2" after using "Sheet 1 of 2" to update the quarter 3 grand total on "Sheet 2 of 2". Is there a good way to fit about 102 rows on one sheet that prints out into two separate pages without a lot of manipulation?

I think stacking two 51-row sections over one another using View > Page Layout to guide me may work, but I don't want to mess anything up. Is there a better way I could do this? I could also back track and just make every mileage sheet contain 2 parts, as I could very well run into this issue in the future when I plan to reuse this sheet.

I can't share any great screenshots because every sheet contains personal information, but here is a portion of my sheet list.

Version: Microsoft® Excel® for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20190) 64-bit

My Excel version:

Microsoft® Excel® for Microsoft 365 MSO (Version 2606 Build 16.0.20131.20154) 64-bit

I am trying to:

Pull a SUM value output from one sheet and add it to the total line of the next sheet using the following formula:

='Sheet 1 of 2'!D47 + D5:D46

The SUM value formula on the source page is as follows:

=SUM(D5:D46)

What I get is 42 cells of the same value. I am new to using Excel, coming from Google Sheets, and have never encountered this before. I want my value printed once, not 42 times.

Is this a formatting issue? I found this support article on support.microsoft.com that goes over this behavior with dynamic array formulas, but I am not using a dynamic array formula here. It should be "'one value + range of values' = one possible value in one cell." My goal here is to carry over the last page's total into this page's running total, because I have too much data for one page and opted to separate them into two sheets.

Here is a reference image on Imgur.

Any advice would be greatly appreciated.