Forum Discussion

Copper Contributor

Jan 26, 2026

Formula help - daily pay vs supplement monthly payments

Hi all, I have two sets of data for bonus calculations. SET ONE is in multiple rows by employee, e.g. the annual pay from 1 Jan to 31 Mar. Then 1 Apr to 31 Dec - when their pay has changed from 1 A...

community

excel

Formulas and Functions

office 365

IlirU

Iron Contributor

Jan 26, 2026

Hi,

In cell D2:

=MAP(B2:B7, F2:F7, G2:G7, LAMBDA(a,b,c, SUM((B12:B19 = a) * C12:C19 * (F12:F19 >= b) * (G12:G19 <= c))))

In cell H2:

=G2:G7 - F2:F7 + 1

In cell K2:

=(C2:C7 * (G2:G7 - F2:F7 + 1)) / I2:I7 * J2:J7

In cell H11:

=G12:G19 - F12:F19 + 1

Hope this helps.

IlirU