This menu driven Payments Summary Auto Reporting interface (see screenshot below) in my Automated Cash Book/Bank Reconciliation App (shown below) taps data it sums into totals from the Cash Book Study the SUMPRODUCT formula in the yellow box shown below... Take note of the syntax and the way range names are used in the formula. Next […]