Numbers formula help needed Sequoia 15.6.1

> Hi Peter_MZ

Using the per milking figures from your spreadsheet (10.29am)

The following is how I want it to read

D4 should read 166 - 2 milkings complete and paid for on 2.1.2026.

D5 starts again and should read 85 - 1 milking complete

D6 should read 169 (D5+D6) - 2 milkings complete

D7 should read 323 ( D5+D6+D7) - 4 milkings complete and paid for on 5.1.2026

D8 starts again and should read 273 - 3 milkings that day at 91ea

D9 should read 339 (D8+D9) - 4 milkings complete and paid for on 7.1.2026

D10 starts again and should read 77 - 1 milking complete

Here is that data in spreadsheet form:

and here is the formula I used in D3:

=C3×B3+(IF(E2="",D2,0))

You always want C3 * D3 (the price per milking multiplied by the number of milking).

To this, you add either the previous row's Running Total, or 0 if you were paid the previous day.

This seems pretty straightforward...

Given what you said, just set the formula of cell D3 to:

=IF(ISBLANK(E3),C3+D2,0)

and fill down the column.

This formula checks the cell E3 to see if it ISBLANK(). If it is (you didn't get paid yet), it adds this row's Per Milking value (C3) to the previous running total cell, D2. If E3 is not blank, it assumed you got paid, so it resets to 0

Please find here a more detailed explanation, especially for the two possible pay variants (Read cell D1 and cell E1 for explanation):

Formula for cell D3:

Formula for cell E3

Again replace WENN with IF and ";" with "," to change formula from German to English style.

Hi,

I used the following spreadsheetThe formula in cell D2 is

It depends slightly whether the amount paid at a date includes the milking fee for this day as well or not.

I use German numbers hence the WENN which is IF in the English version. In addition the German separator ";" must be changed to "," for the English version.