The formula on J2 is =IF(H2>100000,COUNT(J1:J$1)+1,"")
What are the formulas on D15, E15 16 E17 , F15 F16 F17 on the data below
<colgroup><col width="64" style="width: 48pt;">
<col width="72" style="width: 54pt; mso-width-source: userset; mso-width-alt: 2633;">
<col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;">
<col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;" span="4">
<col width="98" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3584;">
<col width="48" style="width: 36pt; mso-width-source: userset; mso-width-alt: 1755;">
<col width="21" style="width: 16pt; mso-width-source: userset; mso-width-alt: 768;">
<tbody>
</tbody>
What are the formulas on D15, E15 16 E17 , F15 F16 F17 on the data below
acc | acc name | quart | JAN-MAR | APR-JUN | JUL-SEP | OCT-DEC | total | ||
A198 | Q1 | 109,800 | x | x | x | 109,800.00 | 1 | ||
A306 | Q1 | 297,370 | 332,980 | x | 12,500 | 642,850.06 | 2 | ||
B089 | Q1 | 80,564 | x | x | x | 80,564.20 | |||
A419 | Q2 new | x | 348,750 | x | x | 348,750.00 | 3 | ||
A424 | Q2 new | x | 1,172,055 | 335,600 | 58,430 | 1,566,085.00 | 4 | ||
D148 | Q2 new | x | 1,181,950 | x | x | 1,181,950.00 | 5 | ||
A429 | Q3 new | x | x | 174,870 | x | 174,870.00 | 6 | ||
A442 | Q3 new | x | x | 10,518,090 | x | 10,518,090.00 | 7 | ||
P329 | Q3 new | x | x | 1,522,500 | 6,880,250 | 8,402,750.00 | 8 | ||
B050 | Q4 new | x | x | x | -32,100 | - 32,100.00 | |||
start Q1 | new | repeat | total | ||||||
Q1 | x | x | 0 | ||||||
Q2 | x | 0 | |||||||
Q3 | x | 0 | |||||||
Q4 | x | 0 |