Forum Discussion
kindly help me with creating a formula
Note: if we take 26 days as an example, that means : 8 x 60 = 480 15 X 120 = 1800 3 x 200 = 600 so total amount : 2880
An alternative:
The formula in B2 is
=SUMPRODUCT((A2>$E$2:$E$4)*(A2-$E$2:$E$4)*($F$2:$F$4-$F$1:$F$3))