One or more items can be recorded per day, as the position number POS.# indicates. The daily total value is output using the SUMPRODUCT() function. I have to enter this (both column ranges) manually so far because the number of rows varies, which is reflected in the first decimal place in POS.#. If there is only one item in the day, only the consecutive INTEGER is output as the position POS.#.
I am failing at the task of automating the daily total value in column [I:I] to the extent that I only connect the row-by-row daily number of cells [I] to a pseudo-cell with a customized SUMPRODUCT() output. One solution may seem luxurious, but it avoids typical input errors that are not immediately apparent.
My very first, simplest formula was tactilely stupid and much less error-prone: (n×a + n×b + n×c …) × (%) + postage, until I discovered SUMPRODUCT().
000_LO-CALC_SUMPRODUCT_v0000_082215.ods (22.8 KB)